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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
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