Convert Rows to Columns in Load Script with history changes

[amit_shetty78]

Hi All,

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

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

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.