Filter business code to check if its 0 and update status as offset

[ShreyaSharma]

Hi Team,

Please find attached data.

Need a logic were for each business code it will check the Amount currency , if its 0 then update status as offset if not then NULL

Thanks

[messi007 · Accepted solution]

@ShreyaSharma,

please see below:

hope that helps,

Regards,

[marcusblackhill]

Hey @ShreyaSharma !

In addition to @messi007  solution, here I attach a way to do that in a automated way parsing the txt you input without the necessity to put in a text input, that way you can input one or many at the same time if you need.

Hope that help!