Load statement script in vertical

[Anonymous]

Hello All,

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);

[krishnacbe]

Hi,

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.

[Anil_Babu_Samineni]

Here we go?

[sunny_talwar]

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