Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Qlik Insider: SaaS capabilities for Data Integration and Analytics, May 25th! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
qliksensetd
Contributor II
Contributor II

Update field values where with values from another table if there is a match

Hi all,

I am struggling with the following:

I have created the following table:

Table1:
Key_1Team_1
A1A
A2B

 

I have created a second table:

Table 2 
Key_2Team_2
Q1F
A1G
Z3Z
A2T

 

I try to update 'Table2.Team_2' field value with 'Table1.Team_1' field value where 'Table2.Key_2' field value match 'Table1.Key_1' field value.

I expect the following result:

Table 2 
Key_2Team_2
Q1F
A1A
Z3Z
A2B

 

I have tried to solve this with combining If exists in combination with lookup. This did not worked.

I would really be grateful if you could help me with this issue.

 

Thanks,

Tarik

 

 

 

Labels (3)
1 Solution

Accepted Solutions
Kushal_Chawda

@qliksensetd 

Table1_map:
LOAD key_1,
     Team_1
FROm table1;

Table2:
LOAD Key_2,
     Team_2,
     applymap('Table1_map',Key_2,Team_2) as Team2_New
FROM table2;

View solution in original post

2 Replies
Kushal_Chawda

@qliksensetd 

Table1_map:
LOAD key_1,
     Team_1
FROm table1;

Table2:
LOAD Key_2,
     Team_2,
     applymap('Table1_map',Key_2,Team_2) as Team2_New
FROM table2;
qliksensetd
Contributor II
Contributor II
Author

Thank you very much for your time and help me! It is working as it should.