Use Dynamic Select to Remove Columns that are not Zero

[mattpeltcfa]

Hello,

I am trying to use the below workflow to parse a .txt file and capture an account balance. The balance sometimes appears in different pieces of the parsed data, so I am looking to dynamically select the balance column that contains the balance and remove the ones that contain zero. All fields are currently VString data types. Can someone please help me with this?

[echuong1 · Accepted solution]

I suggest converting everything to numbers first. From there, you can use a conditional statement to check to see if one of the columns is 0 and if it is, use the second one. 

See attached for an example.

[ImadZidan]

Hello @mattpeltcfa ,

If you don't want to explicitly reference a field name. you can do this.

Just an idea. I hope it helps.

I agree with @echuong1 , field types should be consistent.