Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I'm facing problem in reading multiple files using tFileList. The name of the columns are same for each file but the order in which those column names appear differ from file to file. Due to this the files are not being read and data is not being inserted into the db.
I'm using the format: tFileList----> tFileInputDelimited---->tDBOutput
What schema do I give? I even tried giving the generic schema, but that did not work. And I am giving the right parameters for all the 3 components. Please help me out.
Take a look at the blog. Might give you an idea
https://www.talend.com/blog/2019/10/31/magically-shuffle-columns-talend-dynamic-schema/