Forum Discussion
Issue with Lookupvalue Formula
Hi Chandrashekar
Can you please provide sample data and advise the relationship between the two tables?
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
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?Hello,
If am understand you correctly. am getting Not Found as I have used it in formula.
Just now I copied data which am getting Not Found in separable table(400 records) and used lookupvalues formula where formula is working perfectly.
Is there anyway how to get desired result.
Formula used:
In Task = LOOKUPVALUE(Task[Number],Task[Number],'Task SLA'[Number],"Not Found")
Regards,
Chandrashekar B
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
