I have a quite large excel file (>150 columns) and need to sort the mapped fields precisely for target destination. I use File Reader > Excel Parser > Mapper…
At the moment the fields run A, B,C…BX,BY…GZ. However after dragging the Input Schema fields onto the Mapping Table they are re-ordered A, AA, AB …GY,GZ… X,Y,Z. I need the target schema to be ordered exactly how they are done in the original input. How can this be done?
I tried Sort Snap and Sort Path as $ , $A , just various combinations to no success
Any suggestions on how to avoid ‘manually’ having to set the Fields in the default order. Assume that the default order is mandatory.