mapping load and applymap()

[#1]

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.    

[alex_millan]

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!