Syntax for Load all columns in data editor

[jananireddy]

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

[Anonymous · Accepted solution]

Hi Janani,

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

LOAD *
;
SQL SELECT *
    FROM db.view;

Hope this helps.

[sunny_talwar]

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

LIB CONNECT TO [portfolio(e45_lenovo)];

[portfolio]:

LOAD *;

SQL SELECT * FROM  portfolio;