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

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
max033
Contributor
Contributor

Using Dynamic Schema to load files into Database

My job design is as follows

tfilelist -----> tfileinputdelimited----->tpostgresoutput

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.

Labels (4)
0 Replies