I have 4 columns in a spreadsheet that I need to paste on another workbook. The size and order of these 4 columns on the source sheet vary. The Column names are consistent. I need to paste the columns on the destination workbook in a certain order going by their column name. The solution that I am coming up with is saving each column in a separate collection and then checking the field name, and adding a decision stage to check which column name it matches to, so I can tell BP to write that column at a certain position in the destination book. But I am needing to use 16 decision stages, 4 per column. Is there a better solution?
Sample:
Source (order of columns can vary):
Name | Phone | City | State
On destination, they need to be in this specific order:
Name | City | State | Phone
Thanks,
Sample:
Source (order of columns can vary):
Name | Phone | City | State
On destination, they need to be in this specific order:
Name | City | State | Phone
Thanks,