I created one table as below's screenshot, you can see that, from column H to M, is date format.
The problem is when I load into QlikView by script, the date column will display in number.
So I modified the script:
CrossTable(Month, Data, 7)
[17A JOB List.xlsx]
(ooxml, embedded labels, table is job);
Load *,Date(Num#(Month),'YYYY-MM') as TestedDate Resident Directory;
DROP Table Directory;
However, when I reload, QlikView always pop-up error message:
Table not found
Load *,Date(Num#(Month),'YYYY-MM') as TestedDate Resident Directory
So I confused, I don't know how to revise the script. I have uploaded the QVW file in attachment. Does somebody can help me.
Thx a lot!
Try by giving Proper name to your first loaded table instead of Directory,
Load *,Date(Num#(Month),'YYYY-MM') as TestedDate Resident Table1
Drop Table Table1;
View solution in original post
You're right, seems need to change to another name, and it is working now.