Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

jananireddy
Contributor

Syntax for Load all columns in data editor

I am currently using this script in my data load editor:

[portfolio]:

LIB CONNECT TO [portfolio(e45_lenovo)];

LOAD

[category] as CATEGORY,

[module] as MODULE,

[customeraccountid] as CUSTOMERACCOUNTID,

[customername] as CUSTOMERNAME;

SQL SELECT * FROM  portfolio;

Since now my tables will have increasing number of columns/ renamed columns, can i have a way to avoid mentioning the column names in my script? May be something like this:

[portfolio]:

LIB CONNECT TO [portfolio(e45_lenovo)];

LOAD ALL

SQL SELECT * FROM  portfolio;

Thanks,

Janani

1 Solution

Accepted Solutions
okolyug16
Contributor II

Re: Syntax for Load all columns in data editor

Hi Janani,

I believe you can, I've successfully loaded all columns using the following;


LOAD *
;
SQL SELECT *
    FROM db.view;

Hope this helps.

2 Replies
okolyug16
Contributor II

Re: Syntax for Load all columns in data editor

Hi Janani,

I believe you can, I've successfully loaded all columns using the following;


LOAD *
;
SQL SELECT *
    FROM db.view;

Hope this helps.

MVP
MVP

Re: Syntax for Load all columns in data editor

I think all you need is to replace ALL with a *

LIB CONNECT TO [portfolio(e45_lenovo)];

[portfolio]:

LOAD *;

SQL SELECT * FROM  portfolio;