Load fieldnames automatically within a script

McDataMan — Sat, 16 Nov 2024 20:34:31 GMT

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

Re: Load fieldnames automatically within a script

Brett_Bleess — Tue, 23 Jul 2019 16:07:57 GMT

Have a look at the following Design Blog post, I think it may help, but i am not certain...

Regards,
Brett