Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
lucaL
Partner - Contributor II
Partner - Contributor II

Dynamic xlsx load using dB metadata

Hi all!

I need to load into some dB tables already existing a bunch of xlsx file, that could vary in time (each file has his own target table). What I would like to do would be to load the schema dynamically from the dB table (via dB Metadata tables), load the excel and put it on a csv file, read the csv with a dynamic schema inferred from a file written from the dB Metadata, and load it into the table... So, is there a better way of doing this task? If I read the excel with dynschema, all columns goes as strings... 

Labels (2)
0 Replies