Reading data from text files

[Analytics_Pooja]

Hi

I am trying to read data from multiple txt files using dynamic tool. Each txt file has 8-10 rows of data. I want to transpose each row as a separate column before reading the next file. 

Any help would be much appreciated. 

Best

Pooja 

[Qiu]

@Analytics_Pooja 
Things will get much tricky if the schema of data is different between your input files.

But if same, we can do some thing like below, and note you need to change the delimiter accordingly.

[grazitti_sapna]

Hi @Analytics_Pooja ,

can you please provide some sample data files so we can access your problem solution in a better way.

Thanks!