Discussion board where members can learn more about Qlik Sense App Development and Usage.
I am currently using this script in my data load editor:
LIB CONNECT TO [portfolio(e45_lenovo)];
[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:
Go to Solution.
I believe you can, I've successfully loaded all columns using the following;
LOAD *;SQL SELECT * FROM db.view;
Hope this helps.
I think all you need is to replace ALL with a *