Amount | Currency | Amnt1 | Currency1 |
1 | INR | ||
20 | INR | ||
23 | INR | ||
55 | INR | ||
22 | INR | ||
35 | INR | ||
45 | INR |
On the above data, I want Amnt1 to be moved to Amount and Currency1 to be moved to Currency. Any leads will be much appreciated.
@vinayvnn Does this work for you?
Use a Formula tool.
For field Amount: IF IsEmpty([Amount]) THEN [Amnt1] ELSE [Amount] ENDIF
For field Currency: IF IsEmpty([Currency]) THEN [Currency1] ELSE [Currency] ENDIF
Chris