LOOKUP() returning same value for all rows - BUG ?

AppSheet AppSheet Q&A
, ,
1

Dear All,

Any body having issues with the lookup() expression ?

I am pretty sure that i am using it correctly, as it’s not the first or the hundreds time i use it, but for some reasons the returned values is the same for all rows even though i am using [_THISROW].

I tried a simple table lookup as well and same, something is not right.

Is it only me ?

Example:
Table A

Shipment Date
1 LOOKUP(
[_THISROW].[Shipment],
“Table B”,
“Shipment”,
“Date”)

Table B

Shipment Date
1 31/01/2024 20:26
2

What exactly is the issue with the example you have provided? I don’t see one. The expected returned value by the expression would be “31/01/2024 20:26”

If you are getting something different, then please show us that issue.

3

In above example no issue, but before i was getting 1 let’s say for all records, after digging, it was due to duplicate IDs in the source table.

Thanks for your response