topic Re: Issue in Slowly Changed Field Split Date field into From and to Dates in QlikView

Issue in Slowly Changed Field Split Date field into From and to Dates

d_koti24 — Mon, 26 Nov 2018 14:47:04 GMT

HI all,

I need to split date field as two different fields(FromDate,ToDates).

please find the attached file for Example.

Thanks in Advance.

Koti.

Re: Issue in Slowly Changed Field Split Date field into From and to Dates

sunny_talwar — Mon, 26 Nov 2018 15:03:53 GMT

Try this

VACATION:
LOAD Code, 
     CodeID, 
     FieldDate, 
     Empname,
     Ceil(AutoNumber(RecNo(), Code&CodeID&Empname)/2) as TempField1,
     Mod(AutoNumber(RecNo(), Code&CodeID&Empname), 2) as TempField2
FROM [Temp.xlsx]
(ooxml, embedded labels, table is Sheet2);

FinalTable:
LOAD Code,
	 CodeID,
	 FieldDate as From,
	 Empname,
	 TempField1
Resident VACATION
Where TempField2 = 1;

Left Join (FinalTable)
LOAD Code,
	 CodeID,
	 FieldDate as To,
	 Empname,
	 TempField1
Resident VACATION
Where TempField2 = 0;

DROP Table VACATION;

Re: Issue in Slowly Changed Field Split Date field into From and to Dates

d_koti24 — Tue, 27 Nov 2018 05:01:29 GMT

Thank you stalwar