topic How to Transform the Data in QlikView? in QlikView

How to Transform the Data in QlikView?

hkg_qlik — Fri, 24 Jun 2011 14:19:58 GMT

ACCESS	NTNAME	REDUCTION	REDUCTIONTYPE	NAME	ID	Reduction Object	Red_data
USER	A	1	ACC	ABC	123	A15	1234
USER	A	1	ACC	ABC	123	A2	123
USER	A	1	ACC	ABC	123	A3	456
USER	A	1	ACC	ABC	123	A4	*
USER	A	1	ACC	ABC	123	A5	*
ADMIN	B	2	ACC	XYZ	100	A15	*
ADMIN	B	2	ACC	XYZ	100	A2	*
ADMIN	B	2	ACC	XYZ	100	A3	*
ADMIN	B	2	ACC	XYZ	100	A4	*
ADMIN	B	2	ACC	XYZ	100	A5	*

Transform the above source document into the following in QlikView:

ACCESS	NTNAME	REDUCTION	REDUCTIONTYPE	NAME	ID	A15	A2	A3	A4	A5
USER	A	1	ACCT	ABC	123	1234	123	456	*	*
ADMIN	B	2	ACCT	XYZ	100	*	*	*	*	*

How to Transform the Data in QlikView?

stephencredmond — Fri, 24 Jun 2011 17:12:32 GMT

Hi,

Use a Generic Load:

Generic Load * INLINE [

ACCESS,NTNAME,REDUCTION,REDUCTIONTYPE,NAME,ID,Reduction Object,Red_data

USER,A,1,ACC,ABC,123,A15,1234

USER,A,1,ACC,ABC,123,A2,123

USER,A,1,ACC,ABC,123,A3,456

USER,A,1,ACC,ABC,123,A4,*

USER,A,1,ACC,ABC,123,A5,*

ADMIN,B,2,ACC,XYZ,100,A15,*

ADMIN,B,2,ACC,XYZ,100,A2,*

ADMIN,B,2,ACC,XYZ,100,A3,*

ADMIN,B,2,ACC,XYZ,100,A4,*

ADMIN,B,2,ACC,XYZ,100,A5,*

];

It does actually create several tables but they will be functionally equivalent to what you are looking for (which can be seen by showing them in a table box).

Not sure that it will work perfectly in Section Access, but it should.

Regards,

Stephen

How to Transform the Data in QlikView?

hkg_qlik — Wed, 06 Jul 2011 15:57:36 GMT

Does anyone has a better solution?

The base table will be expanding regularly.

Regards,