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 |
Solved! Go to Solution.
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
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
@phoebe_90
I think we can as below, of course we can a bit more about the header using Dynamic Rename tool.