topic Load statement script in vertical in QlikView

Load statement script in vertical

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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 — Wed, 13 Sep 2017 15:30:01 GMT

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 — Wed, 13 Sep 2017 15:31:16 GMT

Here we go?

sunny_talwar — Wed, 13 Sep 2017 15:33:06 GMT

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