help to set the load statement in vertical, currently it is
LOAD [Salesperson ID], Salesperson, [Distributor ID], Paymnet, Bonus
FROM Salesperson.xlsx (ooxml, embedded labels, table is SALESPERSON);
Bu default all the columns are listed Vertically when you pull in using the Table Files Wizard.
If you have manually typed in the script then I hope it should be manually done.
Here we go?
It is a one time fix, you will need to load a file using Table Files and go to the last tab and make sure that the Max Line Length is set to 1
Retrieving data ...