Hi @UlysseRG,
this could be a first possible approach for a solution:
The files are read in completely, each row one file, and then divided into the individual RECORDS. Each line one RECORD.
The RECORDS are then divided into the individual items. Each line one item.
The original RECORD RowID is used as selection criterion for the groupwise processing of the datasets.
Finally, the column names are created from the FieldNames and each RECORD data is transferred into a row, together with the original file name.
If the memory is not sufficient, the files can be processed individually by using an additional chunk loop.
I hope the solution can help you.
Best regards
Andrew
RecordFiles.knwf (108.8 KB)