Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
sakshi_jain
Contributor II
Contributor II

Get matching value

Hello guys,

I am new to this community so I dont know how to get value from matching text from two different tables and then merge column [value] into one table. Thank You.

Picture shown below:-

3 Replies
asinha1991
Creator III
Creator III

you can join, make sure that common field have same name

 

Table A:

Load Text as JOINFIELD,

VALUE

From excel1;

 

join(TABLE A)

LOAD diificulty_level as JOINFIELD,

raidus 

from excel2;

 

TABLE A will have merged value

 

 

 

sakshi_jain
Contributor II
Contributor II
Author

Thanks i got the solution do you know how to format number from -1 as my data start with -1 but its starting from 0.5 

asinha1991
Creator III
Creator III

can you share an example ? did not understand what you want