Add a blank line in the middle of a spreadsheet tab

[ppatane]

I have a simple workflow that manipulates data a certain way, and I need to add a completely blank row when 1 field changes.  This will only happen once per run, but I can't seem to get the expression right in a Generate Rows tool to add a blank line when the Fam field changes

[Qiu]

@ppatane 
can you provide a bit more details with some sample data and output?

[ppatane]

@Qiu I have a field setup here that when a condition is met, the Decision field becomes 1, otherwise it is 0.  I want to insert one blank line when the Decision field changes from 1 to 0. I don't see how to set that up in the Generate Rows tool.

[Hsandness]

Hi @ppatane, 

If you want to retain the rows that have a Decision value of "0" and return them as null you could use a series of Multi-Row formula tools.

[Hsandness · Accepted solution]

Here's the screenshot, you'd have to combine the true and false output first using a union tool. At the point, you could just delete the filter tool.

[ppatane]

@Hsandness @Qiu Your solution nulls out all data that is on the false side of the Filter tool.  I want ONE null row between the true outputs from the filter and the false outputs from the filter.  Thanks to your info., I came up with a better solution that works, doing exactly what I need it to.

[Qiu]

@ppatane 
It seems that @Hsandness has it worked out. 😁