Converting a raw text file into a data table

[mlauber71]

@Pawel40Adi maybe it would be best to open a new forum entry and describe what you want to do and maybe give us some (dummy) sampel data that would represent your problem. In the meantime you could explore this older collection regarding the import of CSV/TXT files:

Import CSV - This workflow will act as a meta workflow trying to answer...

Also you might want to check if just allowing the dynamic change of file structure in the CSV Reader might solve your problem:

Loop CSV reader, enfore type error

On the Advanced tab of the CSV Reader node, enable support for changing file schemas. [image] You’ll also need to allow changing file specifications in the Loop end node. [image] Alternately, you could do away with the loop and only use the CSV reader node to read all of the files directly and concatenate them: [image] When I do this, everything works without having to change any file schema settings.