Data transformation

[EvansM]

Hello Community,

I need help with attached files. Please review data sample file.

For a customer_id if we find FINAL value in the REFERENCE column I will like to populate value as FINAL irrespective of values per a expected result document.

[IraWatt · Accepted solution]

Hey @EvansM,

This setup achieves this:

Any questions or issues please ask :)
HTH!
Ira

[EvansM]

@IraWatt  Thanks a lot

[IraWatt]

No worries @EvansM ! 😄