Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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
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!
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