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:
Solved! Go to Solution.
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
Hey @fmvizcaino,
Thank you for the solution. Would you be able to provide an example? I'm still relatively new to Alteryx.
@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?
@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.
@fmvizcaino
Thank you, that worked...however "Beginning Inventory" is String data so "Other2" duplicates didn't Null. Any other suggestions?
You need to include all fields in the multi-field formula tool. Select all types of fields and 'all'
Best,
Fernando Vizcaino
Thank you so much. You've been a big help.