topic Re: Data Load Editor in QlikView

Data Load Editor

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

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!

Re: Data Load Editor

devarasu07 — Mon, 19 Jun 2017 06:30:17 GMT

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

Re: Data Load Editor

Anil_Babu_Samineni — Mon, 19 Jun 2017 06:48:54 GMT

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

Re: Data Load Editor

avinashelite — Mon, 19 Jun 2017 07:00:42 GMT

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 .