Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

georgian2132
New Contributor II

Using Subfield in Applymap in Qliksense

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

1 Solution

Accepted Solutions
Employee
Employee

Re: Using Subfield in Applymap in Qliksense

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.

Ricardo Gerhard
OEM Solution Architect
LATAM
6 Replies
agigliotti
Honored Contributor II

Re: Using Subfield in Applymap in Qliksense

please post a screenshot for the error.

Re: Using Subfield in Applymap in Qliksense

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

Re: Using Subfield in Applymap in Qliksense

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

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

- Marcus

Employee
Employee

Re: Using Subfield in Applymap in Qliksense

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.

Ricardo Gerhard
OEM Solution Architect
LATAM
shraddha_g
Honored Contributor III

Re: Using Subfield in Applymap in Qliksense

If possible share sample app with sample data.

georgian2132
New Contributor II

Re: Using Subfield in Applymap in Qliksense

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.

Community Browser