Forum Discussion

Chandrashekar's avatar
Chandrashekar
Icon for Resolver III rankResolver III
4 years ago

Issue with Lookupvalue Formula

Hello,   am trying to get value from Table1 to Table2 where I used below lookupvalue formula but am getting Not Found as value is available in Table1. I tried two formula(as below) but getting sam...
Chandrashekar's avatar
Chandrashekar
Icon for Resolver III rankResolver III
4 years ago

Hello,

I have established relationship on date field. Table1 have unique value(Number) however Table2 have duplicate value(Number).

Unfortunately I cannot share file as it confidential but I copied few records(10 rows) in another table and it is working fine but for huge data(12K) it is not working.

 

Regards,

Chandrashekar B

tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
4 years ago

Chandrashekar 
Yes because in big data you will have duplicates which is the case when LOOKUPVALUE returns blank. Same problem occurres when the data contains blanks, as blanks are treated as duplicates. What kind of result did you receive when applying to big data?