Unable to find Column that is there

[Simon_Bailey]

I have a couple of expressions that can't find a column that is in the table.

It's happening in a LOOKUP and a referrence

I've had it in the past and somehow sorted it. I think I've asked on here before, but I can't find any of my posts after 2019 in my profile, so sorry for asking again

[Rafael_ANEIC-PY]

For your lookup you might want to try using [_THISROW].[Code] instead of [Code], because of this:

As for your dereferencing issue, you might want to run the "Regenerate structure" button for that table.

[Simon_Bailey]

The reference started working again on Friday.
I left the LOOKUP until today, rewrote it and it seeems to be fine now. Must have been a temporary bug. Good that it's working but frustrating that it does it.