Change schema of Input file dynamically

I need to access a set of file names from database, and read those files in my workflow.

I am able to accomplish this, by lopping over returned result from database, and convertinf ppah to a flow variable, and assigning it to file Url.

The problem I am facing is that, the file schema needs to be same for all files read in this manner.

I actually need to read files with 10 columns, 2 columns, 3 columns, etc.

How do I accomplish this?

Hi

I would recommend the Line Reader. It will push each line into one data cell. Collect all of them with a loop end and use the Cell Splitter afterwards.

Please be aware that this only works if column 1 in all of your files refers to the same feature you want to read.

Afterwards you might consider using the Column Auto Type cast node.

Cheers, Iris

1 Like