Add Blank rows in a specific part of data.

[calvincarr29]

I need to add three blank rows that go through 53 columns in a specific section of the data. Is this possible without the text input?  

I need to turn this:

Into this:

 

[fmvizcaino]

Hey @calvincarr29 ,

You can use a combination of a Formula to create a flag, Generate row to create the rows and a Multi-field formula to erase the data from all the new rows.

Best,

Fernando Vizcaino

[calvincarr29]

Hey @fmvizcaino,

Thank you for the solution. Would you be able to provide an example? I'm still relatively new to Alteryx. 

[Qiu]

@calvincarr29 
Just want to confirm are you inserting new rows or change the duplicate columns into blank?

What will be cretiria?

I can see in the "Beginning lnventory" column, the "Machinery & Equipment", "Furniture & Fixtures", "Buildings"  columns became empty in the output.
How about the "Inventory" why it is remaning?

[fmvizcaino · Accepted solution]

Sure @calvincarr29 ;

Here it is.

[calvincarr29]

@Qiu

The data shown is "Beginning" -- Inventory, Machinery & Equipment, Furniture & Fixtures, etc. on top of "Ending" -- Inventory, Machinery & Equipment, Furniture & Fixtures, etc. (The Ending Header didn't appear when I joined them with the union tool)

They are not duplicates. 

I simply need to add three blank rows exactly so I can use the output tool to spit it onto a template within a designated cell range in excel. 

[calvincarr29]

@fmvizcaino

Thank you, that worked...however "Beginning Inventory" is String data so "Other2" duplicates didn't Null. Any other suggestions? 

 

[fmvizcaino · Accepted solution]

You need to include all fields in the multi-field formula tool. Select all types of fields and 'all'

Best,

Fernando Vizcaino

[calvincarr29]

Thank you so much. You've been a big help.