how to move a field.

[luo]

Hi,

I am trying to prepare my data. And I got input like:

Name	Amount
A	-100
A1	50
A2	50
B	-35
B1	35
C	-200
C1	100
C2	30
C3	70

And I want to transfer to:

Name	Amount	D	C
A	100		100
A1	50	50
A2	50	50
B	35		35
B1	35	35
C	200		200
C1	100	100
C2	30	30
C3	70	70

Thank you!!

[cs11]

Believe you could try a formula tool with:

If Regex_match(Right([Name], 1), "\d") THEN [Amount] ELSE Null() ENDIF while creating the new column [D],

then repeat again with IF Regex_Match(Right[Name], 1), "\d") THEN Null() ELSE [Amount] Endif while creating column C

[atcodedog05 · Accepted solution]

Hi @luo ,

Here is a workflow for your requirement.

Input data

Logic : if amount is negative column C or else column D

Output data

Hope this helps.