Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi!
I am loading the data from google drive generated links.
I want to write a script and load all specified tables by one click and keep the list of field names within a script and not to use the load editor.
Of course, it is possible to load with a '*' and it will be like this:
dimProduct:
LOAD *
FROM [https:/...
But I want to load the table with field names and come over the 'Load Editor' as it is time-consuming.
Like this:
FactCustomer:
LOAD AddressLine1,
AddressLine2,
BirthDate,
FROM...
.....
Thanks beforehand
Have a look at the following Design Blog post, I think it may help, but i am not certain...
https://community.qlik.com/t5/Qlik-Design-Blog/Loops-in-the-Script/ba-p/1473543
Regards,
Brett