Error Concatenate CSV Loop

@mauuuuu5 If your task does not allow for a separation or correction of the delimiters you could build a workflow where the data is read as a single column and later split into the real columns. With a try/switch you could determine which is the correct one.

Complications could arise if the delimiters are sometimes used as real data, quotes etc.

You could use the switch just to produce a list of the files and then use the standard CSV or file reader to do the import.

And then there is this. But you for sure are aware of …

2 Likes