Find value in different table without link

User Talk Data processing
1

Let suppose I have table"Perf" with a calculated column “word” (ABC,AAA, BBB, BAC, …)
In another table “Result” I have 2 columns:
One "value’ with all possibilities ABC,AAA,AAB,AAC,…
One “result” with the arbitrary corresponding value (A,B,C,…)

How can I ask Perf.word column to look for corresponding Result.value and return Result.result

There is no link between those table

2

Use data processing - “lookup and copy” should be the right operation:

image
image466×595 6.86 KB

3

Hi thanks

It seems data processing does not work with calculated column. Can you confirm ?

4

Confirmed.

In this case, you need to use “auto add link”

image
image579×807 19.1 KB

5

Tested Ok thanks :+1:

6

This topic was automatically closed 2 days after the last reply. New replies are no longer allowed.