Forum Discussion
Helper IMissing cell values after LOOKUPVALUE in Table View
Thank you for the clarification. It's a significant effort and I appreciate it.
I am sticking to my analysis of the problem which I posted above. The LOOKUPVALUE is not going to find anything because the data it is looking for does NOT exist. Examine the parameters which are passed to the function. Now compare with the data in the table. The row which you expect to match has a different loop3 value. So it will never find anything in the search table.
There are 2 possibilities : 1: I am not explaining my point about the LOOKUPVALUE very well
2: Your understanding of LOOKUPVALUE is not how it really works
----
There is a significant difference in the dataset where everything works ok and the one where it doesn't. For the working dataset, there are effectively 2 sets of 3 rows which have the same key values.
The dataset which does not work has 2 sets of 3 rows too. However, they do not have the same key values (Name, loop1, loop2, loop3)
Have a think and let me know.
Community ChampionThank you for the clarification. It's a significant effort and I appreciate it.
I am sticking to my analysis of the problem which I posted above. The LOOKUPVALUE is not going to find anything because the data it is looking for does NOT exist. Examine the parameters which are passed to the function. Now compare with the data in the table. The row which you expect to match has a different loop3 value. So it will never find anything in the search table.
There are 2 possibilities : 1: I am not explaining my point about the LOOKUPVALUE very well
2: Your understanding of LOOKUPVALUE is not how it really works
----
There is a significant difference in the dataset where everything works ok and the one where it doesn't. For the working dataset, there are effectively 2 sets of 3 rows which have the same key values.
The dataset which does not work has 2 sets of 3 rows too. However, they do not have the same key values (Name, loop1, loop2, loop3)
Have a think and let me know.
WKNOk, I got it now. To date my team and I have never came across different Loop 3 values between the Pre and Post test data till now and thus assumed both will complete the same number of loops at all times. So we are not even aware when the Loop 3 data point is different but just fixated on the missing cell value and how it lead to error reporting. 😅
Your fresh pair of eyes have really helped in this simple error. We will discuss to decide if such data point in this scenario should be taken into consideration. Thanks for your time. 😇