Get matching value

[sakshi_jain]

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:-

[asinha1991]

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]

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]

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