Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
sakshi_jain
New 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
Contributor III

Re: Get matching value

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
New Contributor II

Re: Get matching value

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
Contributor III

Re: Get matching value

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