Adding empty row

[arkimp]

I want to add an empty row after every 4 rows in the output. Please provide the best possible to achieve this. 

[Martyn]

A more elegant solution escapes me at the moment, but you could try this......

[arkimp]

Thanks for the solution.  However, it is not working, if the input file has multiple fields 

[JamesCharnley]

I would use Generate Rows to create a kind of fractional Record ID with no other rows, then when you union it on it should be null in all other columns.

Let me know if that helps.

James

[arkimp]

Thanks for the solution. One small issue is, we are getting multiple null rows.  Need to remove all the NULL rows from the end of the data rows. 

[JamesCharnley]

A couple of different ways I might handle this. Could change the condition expression in the generate rows to make fewer rows, or add a multi row afterwards to add a tags to null rows we want to keep, and then cleanse the rest out. I've attached one way that works.

[binuacs]

@arkimp Can you provide a sample input file with mocked data?

[Christina_H · Accepted solution]

Here's my version

[Rutujabothara]

Any Solution of adding 3 Rows at only the start for the output?