Parsing file had iterative rows as a record

[Saraabdi955]

Hi everyone,

I have a log file (attached) that every record was placed in three lines.

How can I parse a file like this?

[Felipe_Ribeir0 · Accepted solution]

Hi @Saraabdi955 

Here is a way of doing this:

If the provided answer helped you to solve the problem/was correct, please accept it as a solution :)

Thanks.

[Saraabdi955]

@Felipe_Ribeir0 

Thanks,

Please give me a short description of what you do.

[Felipe_Ribeir0]

Hi @Saraabdi955 

1) I configured the input as .flat without parsing the data directly with the input tool. If you take a look at your data, because of the {C2}, and APPID rows, these rows dont have "," to parse, so because of this, you would receive error messages if you tried to parse the file with the input tool.

2)After that, i used the text to columns configured to parse the field with ",". I manually selected the number of columns (5 columns) to parse based on the data.

3)I used the filter tool to remove the unwanted rows

4)I used the dynamic rename tool to take the field name from the first row.

If you have any specific doubts, just send it here!