fmpuser0

Adding Multiple Names to A Pax List

Discussion created by fmpuser0 on Oct 30, 2018
Latest reply on Oct 31, 2018 by fmpuser0

I have the following report containing a list of flights:

 

Flt# /Date / From / To

Data looks like

101 1/1/18 AAA BBB

101 1/2/18 BBB CCC

102 1/3/18 CCC DDD

102 1/3/18 DDD EEE

102 1/4/18 EEE FFF

 

This information is coming from one single table that contains one single record for each report line. So basically, the report looks like the table.

 

Now I need to add the new field PAX NAMES to the report. There are multiple PAX NAMES for each flight leg and each name is contained in one Excel row; for example,

 

101 1/1/18 AAA BBB  Smith

101 1/1/18 AAA BBB  Jones

 

101 1/2/18 BBB CCC Jones

101 1/2/18 BBB CCC Davis

101 1/2/18 BBB CCC Miller

 

102 1/3/18 CCC DDD Smith

102 1/3/18 DDD EEE Williams

102 1/3/18 DDD EEE Brown

 

102 1/4/18 EEE FFF Smith

 

How can I add the PAX NAMES to my report keeping all names on the same flight in one record, ie like this:

 

101 1/1/18 AAA BBB  Smith, Jones

101 1/2/18 BBB CCC Jones, Davis, Miller

102 1/3/18 CCC DDD Smith, Williams, Brown

102 1/4/18 EEE FFF Smith

 

Thanks in advance to whoever can help with this.

Outcomes