Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have created a mapping table as mentioned below:
Exceptions:
mapping LOAD
TRANSACTION_ID,
date(timestamp#(DB_MODIFIED_DATETIME,'MM/DD/YYYY hh:mm:ss'))&'~'&
date(timestamp#(DB_CREATED_DATETIME,'MM/DD/YYYY hh:mm:ss'))&'~'&
RULE_NAME&'~'&
date(timestamp#(DB_MODIFIED_DATETIME,'MM/DD/YYYY hh:mm:ss'))&'~'&
EXCEPTION_STATUS as Exceptions
Resident Temp;
Drop Table Temp;
I am using this mapping table in another load statement as :
subfield(ApplyMap('Exceptions',TRANSACTION_ID,'NA'),'~',1) as Exception_Resolved_Date,
subfield(ApplyMap('Exceptions',TRANSACTION_ID,'NA'),'~',2) as Exception_Created_Date,
subfield(ApplyMap('Exceptions',TRANSACTION_ID,'NA'),'~',3) as RULE_NAME,
subfield(ApplyMap('Exceptions',TRANSACTION_ID,'NA'),'~',5) as EXCEPTION_STATUS,
subfield(ApplyMap('Exceptions',TRANSACTION_ID,'NA'),'~',4) as Exception_Created_Date_Open,
But I am getting an error stating that Mapping ID not found.
Please help.
TIA
Regards,
Rishikesh
Just try to remove the script below and see if the table Exceptions will be created:
Exceptions:
LOAD
TRANSACTION_ID,
date(timestamp#(DB_MODIFIED_DATETIME,'MM/DD/YYYY hh:mm:ss'))&'~'&
date(timestamp#(DB_CREATED_DATETIME,'MM/DD/YYYY hh:mm:ss'))&'~'&
RULE_NAME&'~'&
date(timestamp#(DB_MODIFIED_DATETIME,'MM/DD/YYYY hh:mm:ss'))&'~'&
EXCEPTION_STATUS as Exceptions
Resident Temp;
Drop Table Temp;
The problem could be the table concatenating fields.
please post a screenshot for the error.
I would do 5 separate Mapping Loads, one for each thing want to ApplyMap()
Try it again by just adding this as a dummy-field to your load:
ApplyMap('Exceptions',TRANSACTION_ID,'NA') as Dummy
- Marcus
Just try to remove the script below and see if the table Exceptions will be created:
Exceptions:
LOAD
TRANSACTION_ID,
date(timestamp#(DB_MODIFIED_DATETIME,'MM/DD/YYYY hh:mm:ss'))&'~'&
date(timestamp#(DB_CREATED_DATETIME,'MM/DD/YYYY hh:mm:ss'))&'~'&
RULE_NAME&'~'&
date(timestamp#(DB_MODIFIED_DATETIME,'MM/DD/YYYY hh:mm:ss'))&'~'&
EXCEPTION_STATUS as Exceptions
Resident Temp;
Drop Table Temp;
The problem could be the table concatenating fields.
If possible share sample app with sample data.
Help appreciated people.
But I found out the answer after ricardogerhard 's reply. Thanks ricardogerhard
While concatenating I used only 4 fields but in applymap I was using 5. That is why I was getting the error for the 5th applymap.