topic Re: convert colum data in multiple colums in QlikView

convert colum data in multiple colums

Tue, 25 Nov 2014 16:11:05 GMT

i have this example table:

Account_id	Mod_id	Mod_des
1001	1	A
1001	2	B
1002	3	C
1003	1	A
1003	4	D

and i need to transform it to something like this

Account_id	A	B	C	D
1001	1	1	0	0
1002	0	0	1	0
1003	1	0	0	1

How i can do this??

thanks!!

Re: convert colum data in multiple colums

JonnyPoole — Tue, 25 Nov 2014 16:27:10 GMT

I would suggest a pivot table... drag the 2nd dimension (Mod_des) as the column headers and use an expression formula of : count (distinct Mod_id)

Re: convert colum data in multiple colums

rubenmarin — Tue, 25 Nov 2014 16:30:42 GMT

Hi Carlos, plase check attachment.

Re: convert colum data in multiple colums

MarcoWedel — Tue, 25 Nov 2014 16:54:58 GMT

In the script you could use a generic load:

Generic LOAD Account_id, Mod_des, 1

From Yoursource;

hope this helps

regards

Marco

Re: Re: convert colum data in multiple colums

MarcoWedel — Tue, 25 Nov 2014 17:06:25 GMT

like this:

Generic LOAD Account_id, Mod_des, 1
FROM [http://community.qlik.com/thread/143544] (html, codepage is 1252, embedded labels, table is @1);

hope this helps

regards

Marco

Re: convert colum data in multiple colums

ashfaq_haseeb — Tue, 25 Nov 2014 17:06:50 GMT

Try like this

DataOrig:

Generic Load distinct Account_id, Mod_des,Mod_id;

LOAD * Inline [

Account_id,Mod_id,Mod_des

1001,1,A

1001,1,B

1002,1,C

1003,1,A

1003,1,D

];

Regards

ASHFAQ

Re: convert colum data in multiple colums

Tue, 25 Nov 2014 18:26:20 GMT

hi Marco,

the table box that you have in the application its the result that i need but i need it as a qvd because i have to do it another transformations.

how i can do it?

Re: convert colum data in multiple colums

Peter_Cammaert — Tue, 25 Nov 2014 23:18:08 GMT

To throw all those tables resulting from a GENERIC LOAD back together in order to be able to export to a QVD, see this post by Henric:

http://community.qlik.com/blogs/qlikviewdesignblog/2014/03/31/generic

although he strongly advises against using this code.

Best,

Peter