https://community.qlik.com/t5/Talend-Studio/Dynamic-xlsx-load-using-dB-metadata/m-p/2497821#M141641 <P>Hi all!</P> <P>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...&nbsp;</P> Fri, 13 Dec 2024 06:15:51 GMT lucaL 2024-12-13T06:15:51Z https://community.qlik.com/t5/Talend-Studio/Dynamic-xlsx-load-using-dB-metadata/m-p/2497821#M141641 <P>Hi all!</P> <P>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...&nbsp;</P> Fri, 13 Dec 2024 06:15:51 GMT https://community.qlik.com/t5/Talend-Studio/Dynamic-xlsx-load-using-dB-metadata/m-p/2497821#M141641 lucaL 2024-12-13T06:15:51Z