Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
viveksingh
Creator III
Creator III

Multiple Apply map

Hi Experts,

I have requirement on multiple lookup/ applymap

Below is data:

Table_1:

NAMEIDBRACH_CD
A112367701
A26431652
B57891245

Staff:

NAMEIDBRANH_CD
A112367707
A26431631
A37321701
B13854622
B57891245

Refer:

NAMEIDBRANCH_NAMEBRANCH_CD
A112367AMPG707
A3679KPG708
A57028KL601
B57891BKJL245

Now,

First, if NAME and ID in Table_1 is matched with NAME and ID in Staff table then it should bring the BRANCH_CD from staff table into Table_1. This will add new column into Table_1. but again , if the NEW_BRANCH_CD(this is new column where we got with applymap) in Table_1 matches with BRANCH_CD in Refer table, then it should bring BRANCH_CD(old_code) from Table_1.

1 Solution

Accepted Solutions
Gysbert_Wassenaar

see attached qvw


talk is cheap, supply exceeds demand

View solution in original post

5 Replies
Gysbert_Wassenaar

I don't understand what you're trying to do (I see no NEW_BRANCH_CD field anywhere, but you can nest applymap:

ApplyMap('map1', FieldX, ApplyMap('map2', FieldX, ...etc ))


talk is cheap, supply exceeds demand
viveksingh
Creator III
Creator III
Author

NEW_BRANCH_CD is newly added column in Table_1 which is on basis of applymap from Staff table.

but my second applymap is reverse, which means, if NEW_BRANCH_CD is matched with BRANCH_CD in Refer table then it should bring BRANCH_CD from Table_1

Gysbert_Wassenaar

Then you need to create a new mapping table after you've modified Table 1. Then create a new  table using the Refer table as source and the new mapping table created from the modified Table 1.


talk is cheap, supply exceeds demand
viveksingh
Creator III
Creator III
Author

Hi, Thanks for the reply, with first apply map I have Got like below.

Table_1_TEMP:

NAMEIDBRACH_CDNEW_BRANCH_CD
A112367701707
A26431652631
B57891245245

Refer:

NAMEIDBRANCH_NAMEBRANCH_CD
A112367AMPG707
A3679KPG708
A57028KL601
B57891BKJL245

using above Refer table I have to do apply map, if Table_1_TEMP.NEW_BRANCH_CD= Refer. BRANCH_CD

and Table_1_TEMP.ID=Refer.ID then I have to replace with Table_1_TEMP.BRANCH_CD


expected:

Table_1_TEMP:

NAMEIDBRACH_CDNEW_BRANCH_CD
A112367701701
A26431652631
B57891245245

Gysbert_Wassenaar

see attached qvw


talk is cheap, supply exceeds demand