Assigning accounts and transaction types to data

[tiverson]

I have a small set of data that I want to assign accounts and transaction codes to, based on whether the account is <>0.

If the amount is >0, then I want to assign transaction code 05 to the ST account and 06 to the LT account

Data

Account mapping table

Desired output

[CathyS_Slalom]

Hi @tiverson, see attached example workflow. 

[binu_acs]

@tiverson 

[tiverson]

@binu_acs , your solution worked, I just needed to add a formula to switch signs with the LT account amount