Use SQL to Data Map in Oracle ARCS for New Account with Different Amount source

[Nyxs_Inquisitor]

In Oracle ARCS, source to target mapping for the AR subledger maps source "AMOUNTA" to target "Amount". This is for one account 11111. But the new account 11112 uses "AMOUNTB" instead. Integration setup/Import format only allows one source to map to the target. However, workflow/data load mapping allows for #SQL code.

In another integration, this #SQL code worked for a particular text field in data load mapping:

<span>CASE WHEN UD9 IS NULL THEN ' ' ELSE UD9 END</span>

How can we use #SQL to pull one source amount "AMOUNTA" to target "Amount" for account 11111 and another source amount "AMOUNTB" to same target "Amount" for account 11112?

(Note: the amount field is not directly available in data load mapping like the text field is for the working code)

 

[cwstudio2020]

You can try this: CASE WHEN account = '1111' THEN AmountA ELSE AmountB END AS Amount. This way, when the Account is '1111', the Amount field will have the value of AmountA; otherwise, the Amount field will have the value of AmountB.