Combine Multiple Cell Values into One

[niegel]

Hi,

Wondering if it's possible to combine multiple cell values in qlikview as I'll be using the cell values for a script that would need all the selected values concatenated in one line.

Here's an example:

TABLE      COMPANY

1               APPLE

1               GOOGLE

1               MICROSOFT

2               MACYS

2               ROSS

2               AMC

3               KFC

3               TACO BELL

3               A&W

I'd like to have a table that would show me:

TABLE     COMPANY

1               APPLE, GOOGLE, MICROSOFT

2               MACYS, ROSS, AMC

3               KFC, TACO BELL, A&W

Wondering if it's possible to do.

[GabrielAraya · Accepted solution]

Check this:

Example:

Load * Inline [

TABLE,COMPANY

1,APPLE

1,GOOGLE

1,MICROSOFT

2,MACYS

2,ROSS

2,AMC

3,KFC

3,TACO BELL

3,A&W

];

Final:

Load

    TABLE,

    concat(COMPANY,';') as COMPANYList

Resident Example

Group By TABLE;

Drop table Example;

BR

Gabriel

[niegel]

Great, I didn't know that concat() can be used in qlikview.

I can even use it as a Chart Expression for a pivot table! Wonderful!

Thanks!

[brooksc57]

Thank you! So many versions....Join, Merge, Concat...was hard to find...via search.

-------------------------------------------------------------------------

Excel - macro

Access - I forget of the top of my head

SSMS - For XML Path in the T-SQL script side

SSRS - Join( ) on the presentation side

Qlikview - Concat( ) Group By