How to add column according to condition?

[phoebe_90]

After I got column A and B, how can I using tool to get column C-H?

A	B	C	D	E	F	G	H
Amount	Over due days	0 days	1-30days	31-60days	61-90days	91-120days	>120days
1000	0	1000
2000	10		2000
3000	40			3000
4000	70				4000
5000	100					5000
6000	140						6000

[ShankerV]

Hi @phoebe_90 

Please use Formula tool.

Formula tool settings:

Output column: 0 days

IF [Over due days] = 0
THEN [Amount]
ELSE null()
ENDIF

Data type: V_String

Many thanks

Shanker V

[ShankerV · Accepted solution]

Hi @phoebe_90 

Likewise please replicate the above by using + symbol to add.....

Formula tool settings:

Output column: 31-60days

IF [Over due days] >= 31 AND [Over due days] <=60
THEN [Amount]
ELSE null()
ENDIF

Data type: V_String

Formula tool settings:

Output column: 1-30days

IF [Over due days] >= 1 AND [Over due days] <=30
THEN [Amount]
ELSE null()
ENDIF

Data type: V_String

Formula tool settings:

Output column: >120days

IF [Over due days] >120
THEN [Amount]
ELSE null()
ENDIF

Data type: V_String

Many thanks

Shanker V

[Qiu · Accepted solution]

@phoebe_90 
I think we can as below, of course we can a bit more about the header using Dynamic Rename tool.