How can I change the position of the columns? Some of the columns I have to move come from my input file, some others I create myself with the multi-field and the formula tool, but I have to move quite a few of them around. I haven't been able to find any documentation on this. Any ideas? Thanks
Solved! Go to Solution.
Attached sample flow .
somehow I could not pad 0s in string like 1:Key so I used string manipulation to solve this.
PadLeft( SubString([_CurrentField_],0,FindString([_CurrentField_],":")),3,"0")+SubString([_CurrentField_],FindString([_CurrentField_],":"),Length([_CurrentField_]))
Also used separate dynamic select for - ve values.
Thanks,
Krishna