Using Subfield in Applymap in Qliksense

[Anonymous]

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

[agigliotti]

please post a screenshot for the error.

[Anonymous]

I would do 5 separate Mapping Loads, one for each thing want to ApplyMap()

[marcus_sommer]

Try it again by just adding this as a dummy-field to your load:

ApplyMap('Exceptions',TRANSACTION_ID,'NA') as Dummy

- Marcus

[Ricardo_Gerhard · Accepted solution]

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.

[shraddha_g]

If possible share sample app with sample data.

[Anonymous]

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.