cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ratercero Member
Member

lookup value on table2, based on first (date) duplicate (table2) and values of 2 columns (table2)

Hello,

 

I have table1 with batch numbers and dates, and table2 withdates, duplicate batch numbers, defect description and status.

Objective is:

Find batch number from table1 on table2, and return value only if is the earliest date, defect="Tinto" and Status <> "Aprobado"

I tried creating a calculatedtable with all this criteria filtered but when I do the Lookup column on table1 returns error, "A table with multiple values was supplied where a singlevalue was expected."

Any Ideas?




 

3 REPLIES 3
v-huizhn-msft Super Contributor
Super Contributor

Re: lookup value on table2, based on first (date) duplicate (table2) and values of 2 columns (table2

Hi @ratercero,

There is one(Table1) to many(Table2) relationship in your resource table. There are mutiple table2 values for each row in table1, it can not to identify which is the right when you create a calculated Lookup column, so it returns a error message.

For your scenario, we only can create lookup value in table2, but we are not able to create lookup column in table1.

Best Regards,
Angelia

ratercero Member
Member

Re: lookup value on table2, based on first (date) duplicate (table2) and values of 2 columns (table2

Thank you
v-huizhn-msft Super Contributor
Super Contributor

Re: lookup value on table2, based on first (date) duplicate (table2) and values of 2 columns (table2

Hi @ratercero,

Have you resolved your issue? If you have, please mark the helpful reply as answer, which will help more people.

Best Regards,
Angelia