topic Re: Inverse a column in QlikView

Inverse a column

louisernould — Fri, 31 Jul 2015 10:24:44 GMT

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

Re: Inverse a column

Fri, 31 Jul 2015 10:30:41 GMT

Hi Loius,

you can use concat for this

Load

Product,

Concat(Specifics, ',') As Specifics

hope that helps

Joe

Re: Inverse a column

PrashantSangle — Fri, 31 Jul 2015 10:31:19 GMT

Hi,

Use Concat()

try

Load Product,

Concat(Specifies,',') as Specifies1

From TableName

Group By Prouduct;

Regards

Re: Inverse a column

Fri, 31 Jul 2015 10:33:22 GMT

See example

Re: Inverse a column

sorrakis01 — Fri, 31 Jul 2015 10:36:54 GMT

Try this

Regards

Re: Inverse a column

Gabriel — Fri, 31 Jul 2015 10:49:17 GMT

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;

Re: Inverse a column

louisernould — Fri, 31 Jul 2015 12:07:29 GMT

Thank you for your answers !

well I wasn't so complicated ^^

The concat formula Works great !