Inverse a column

[louisernould]

Good Morning,

I'm trying to solve a situation, but I think I need some help.

I have one excel Table:

product	specifics
A	1
A	2
B	1
B	3
B	4

And when I load it on Qlikview, I would like to transcript the table in order to have this results at the end :

Product	Specifics
A	1,2
B	1,3,4

Actually I think I can do it on Excel, but I have much more products, so I cannot do it by hand.

Is anybody can help me on this problem ?

Thank you very much

Louis

[#2 · Accepted solution]

Hi Loius,

you can use concat for this

Load

Product,

Concat(Specifics, ',') As Specifics

hope that helps

Joe

[PrashantSangle]

Hi,

Use Concat()

try

Load Product,

Concat(Specifies,',') as Specifies1

From TableName

Group By Prouduct;

Regards

[#4]

See example

[sorrakis01]

Hi

Try this

Regards

[Gabriel]

Hi,

Try this. You need to use NoConcatenate if you still want to re-used Fields name in your final table and then
Group By will help as well

QV_Data:

LOAD
* Inline [
Product, Specific
A,1

A,2
B,1
B,3
C,1
C,4
];

NoConcatenate
Final_Table:
LOAD
  Product,
  Concat(Specific,';') AS Specific
  Resident QV_Data
  group by Product;
DROP Table QV_Data;

[louisernould]

Thank you for your answers !

well I wasn't so complicated ^^

The concat formula Works great !