Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Data Load Editor

Hi,

I have recently reinstalled Qlikview and I have the below issue, when loading data, Qlikview puts all the fields in a paragraph instead of listing them.

How can I make the default setting to arrange the fields in a column instead of a long paragraph.

Current Scenario when loading data below:

LOAD Customer, Name, Region, Area, Branch, CustomerClass, CustomerType, ArStatementNo, CreditLimit,

     CustomerOnHold, Email, RouteCode, Salesperson, ShortName, TermsCode

Desired Scenario:

LOAD Customer,

  Name,

  Region,

  Area,

  Branch,

  CustomerClass,

  CustomerType,

  ArStatementNo,

  CreditLimit,

     CustomerOnHold,

     Email,

     RouteCode,

     Salesperson,

     ShortName,

     TermsCode

Can someone please assist?  I have no idea where to adjust these settings, so I've had to adjust the script accordingly all the time.

Thanks in Advance!

3 Replies
devarasu07
Master II
Master II

HI,

While loading the table into qlikview, use the column option instead of (Row/ structured option). then it should give expected column listing option. tks

Capture.JPG

Anil_Babu_Samineni

How you are loading? I meant, DB or Table files? It will come default

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
avinashelite

If your loading from the DB then use the Column option in the script ...and if your loading from any flat files its should get arranged automate automatically .