Convert Rows to Columns in Load Script with history changes

amit_shetty78 — Sat, 16 Nov 2024 21:15:14 GMT

Hi All,

I have a dataset where slowly changing data is stored in the following format with key value pairs stored in rows:

I need some help to transform this data in qlik to be stored in the following format:

StartDate	EndDate	ID	Name	Status	Group	Sub Group
02/11/2018	19/11/2018	FTID15	Name1	Active	Group1	SUB Group1
20/11/2018	19/12/2018	FTID15	Name2	Active	Group1	SUB Group1
20/12/2018	23/01/2019	FTID15	Name3	Active	Group1	SUB Group1
24/01/2019	20/02/2019	FTID15	Name4	Active	Group1	SUB Group1
21/02/2019	27/02/2019	FTID15	Name5	Active	Group1	SUB Group1
28/02/2019	NULL	FTID15	Name5	Active	Group1	SUB Group2
02/11/2018	NULL	FTID12	Namex2	Active	Group2	SUB Group13

Here the dimension value are not just limited to the 4 mentioned in the example. This can vary and needs to be loaded automatically.

Appreciate any help with this.

Thanks.

topic Convert Rows to Columns in Load Script with history changes in App Development