https://community.qlik.com/t5/Talend-Studio/Using-Dynamic-Schema-to-load-files-into-Database/m-p/2288128#M61645 <P>My job design is as follows</P><P>tfilelist -----&gt; tfileinputdelimited-----&gt;tpostgresoutput</P><P></P><P></P><P>I am loading data from multiple file into DB tables using dynamic schema. The issue i am facing is since the input is from a file all the columns are considered as Character and the table is created with all the columns as char. I have a few date , float and int columns which need to be reflected in the datatype of the columns in the Database. Please let me know if there is a workaround.</P> Sat, 16 Nov 2024 01:35:43 GMT max033 2024-11-16T01:35:43Z https://community.qlik.com/t5/Talend-Studio/Using-Dynamic-Schema-to-load-files-into-Database/m-p/2288128#M61645 <P>My job design is as follows</P><P>tfilelist -----&gt; tfileinputdelimited-----&gt;tpostgresoutput</P><P></P><P></P><P>I am loading data from multiple file into DB tables using dynamic schema. The issue i am facing is since the input is from a file all the columns are considered as Character and the table is created with all the columns as char. I have a few date , float and int columns which need to be reflected in the datatype of the columns in the Database. Please let me know if there is a workaround.</P> Sat, 16 Nov 2024 01:35:43 GMT https://community.qlik.com/t5/Talend-Studio/Using-Dynamic-Schema-to-load-files-into-Database/m-p/2288128#M61645 max033 2024-11-16T01:35:43Z