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

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
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