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

[Hussein_Osseily]

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

[WillowMobileSys]

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.

[Hussein_Osseily]

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