Join two tables

[youss123]

Hi all,

I have a calculated expression which concatenates 5 values from a column and make them as a single number. 

I have a tabt that I pulled from excel which, for each combination of 5 numbers gives a value between 0 and 1.

can I join the two tables in such a way that I have the correct value between 0 and 1 of each 5 number combination of my calculated expression?

Calculated Expression:

Concat({ <[filter1] ={'v1'},[filter2]={'v2'},[KEY]={'v_1','v_2','v_3','v_4','v_5'} >}[resp_value] , '')

Any help will be appreciated

best regards

[rwunderlich]

The best approach is to create the calculated field in the script and name it the same as "Col1".

-Rob

[danialclose]

---

@rwunderlich wrote:

The best approach is to create the calculated field in the script and name it the same as "Col1".

-Rob friday night funkin

---

Will do. Thank you!!