How to Transform the Data in QlikView?

[hkg_qlik]

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	*	*	*	*	*

[stephencredmond]

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

[hkg_qlik]

Does anyone has a better solution?

The base table will be expanding regularly.

Regards,

H