Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i have this script
file_Mapping:
MAPPING
LOAD
Policy_No.,
date(floor(Policy_Effective_Date_Update)) as
Policy_Effective_Date_Update
FROM
[Mapping_ffile.xlsx]
(ooxml, embedded labels, table is [Mapping_ffile]);
and
file_Mapping:
LOAD
[Policy #],
date(Floor(ApplyMap('PSD_Mapping',[Policy #]))) as date_test,
FROM
Member_file_test.qvd
(qvd);
so when i check date_Test file this shows incorrect format like below image
You may need to format is after you floor it. using Date function
Also i would double check the format the format of the timestamp from excel. Load it directly into a table without floor and check the format and data type you are getting
i did all that but nothing helps i chnage the format of date in properties and also in excel but sam thing appears
What is the format of the date field in the source Excel file?
DD-MMM-YYYY
file_Mapping:
MAPPING
LOAD
Policy_No.,
date(date#(floor(Policy_Effective_Date_Update),'dd-mmm-yyyy'),'dd-mmm-yyyy') as
Policy_Effective_Date_Update
FROM
[Mapping_ffile.xlsx]
(ooxml, embedded labels, table is [Mapping_ffile]);
this shows an error
MAPPING requires 2-column input
Couple of Design Blog posts that may be of some use to check your logic etc.
https://community.qlik.com/t5/Qlik-Design-Blog/Mapping-and-not-the-geographical-kind/ba-p/1463192
https://community.qlik.com/t5/Qlik-Design-Blog/Mapping-as-an-Alternative-to-Joining/ba-p/1473454
You can use the following link to search yourself in this area as well:
https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog
Regards,
Brett