Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
AWS Degraded - You may experience Community slowness, timeouts, or trouble accessing: LATEST HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

mapping load and applymap()

Hi,

Can anyone tell me if anything wrong in the script?

I want to add a field CREATED_DATE to the tbl (Tbl)

Though it's working fine but seeing only one value for one %RULE_ID

temp_RULE_DATE:
LOAD %RULE_ID,
     CREATED_DATE
FROM
[..\..\External Data\Rule CREATED DATE.xlsx]
(ooxml, embedded labels, table is Sheet1);

Map_RULE_DATE:
Mapping
LOAD %RULE_ID,
     CREATED_DATE
     Resident temp_RULE_DATE;

Tbl:
load %RULE_ID,
     PRODUCT_NAME,
     PRODUCT_CATEGORY,
     CITY,
     STATE
ApplyMap('Map_RULE_DATE',%RULE_ID)as Created_Date

from [..QVD\Tbl.qvd](qvd);

Thanks.    

10 Replies
alex_millan
Creator III
Creator III

As Philippe advised you, I would load directly from your Excel and format the date:

Date(DATE_FIELD, 'MM/DD/YYYY')

That would avoid your problems with 41709, etc...

Cheers!