Discussion Board for collaboration related to QlikView App Development.
There is no way to split from single table. But could be work using multi loads like
LOAD Date1 as DateField, 'Date1' as Flag, Sales FROM Book1.xlsx
(ooxml, embedded labels, table is Sheet1);
LOAD Date2 as DateField, 'Date2' as Flag, Sales FROM Book1.xlsx
LOAD Date3 as DateField, 'Date3' as Flag, Sales FROM Book1.xlsx
LOAD Date(DateField) AS Date,
Load Date(MinDate + IterNo() -1) AS Date While (MinDate + IterNo() - 1) <= Num(MaxDate);
Load Min(DateField) AS MinDate, Max(DateField) AS MaxDate RESIDENT Fact;
Does this help ? HIC got a solution for you here i guess.
Yes, as Anil suggested, load each date in a separate load statement. There should be no difference in the pattern whether the dates are in the same or different tables.