I have a file that contains multiple records which are of a differing recordtype. This means that certain record types have more columns than another.
The delimiter is a pipe.
I tried to use the delimited node which reads the first record but errors the remaining ones.
I cant name headers as the first record doesnt have the same as the other records.
Ultimately I wish to load the whole file and then split on record type which is the first column in the file.
Any advice appreciated.
Please sign in to leave a comment.