Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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:-
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
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
can you share an example ? did not understand what you want