How insert a row based on the row count Into a existing excel sheet

[Parthasarathi]

Hi All,

I have a excel sheet with 1000+ rows of data with two categories, based on the category column I need to insert a new row in the excel sheet. 

Category1 - 700 rows

Category2 - 300 rows

Have to insert a new row in Category1 at position 701. Someone please help me with this and thanks in advance.

[IraWatt]

Hey @Parthasarathi,

Its hard to suggest ion method without any example data. But If you just want to append the new data to the bottom of each catagory you could use a method like this:

The record ID Tool keeps track of the original order. The union adds the new data then the multirow formula assigns a record ID number grouped on category and finally we sort the result.

The community has some quick and easy videos on formulas and the Formula Tool here https://community.alteryx.com/t5/Interactive-Lessons/tkb-p/interactive-lessons/label-name/Writing%20...

Any questions or issues please ask

Ira Watt
Technical Consultant
Watt@Bulien.com 

[Parthasarathi]

Hi,

Thank you for your quick reply. Actually the table in the excel will look like the below. I need to insert one or more rows after all the "Reverse" category. If the category is "New File" then I have to insert the rows after all the New File rows.

Source	Original Name	Clean Name	Name as on App	Dynamic ID
Reverse	New Company 1, City Name, State	New Company 1	Company 1
Reverse	New Company 2, City Name, State	New Company 2	Company 2
Reverse	New Company 3, City Name, State	New Company 3	Company 3
Reverse	New Company 4, City Name, State	New Company 4	Company 4
Reverse	New Company 5, City Name, State	New Company 5	Company 5
Reverse	New Company 6, City Name, State	New Company 6	Company 6
Reverse	New Company 7, City Name, State	New Company 7	Company 7
Reverse	New Company 8, City Name, State	New Company 8	Company 8
New File	New Company 9, City Name, State	New Company 9	Company 9
New File	New Company 10, City Name, State	New Company 10	Company 10
New File	New Company 11, City Name, State	New Company 11	Company 11
New File	New Company 12, City Name, State	New Company 12	Company 12
New File	New Company 13, City Name, State	New Company 13	Company 13
New File	New Company 14, City Name, State	New Company 14	Company 14
New File	New Company 15, City Name, State	New Company 15	Company 15

[IraWatt · Accepted solution]

Ah okay so does my setup work here:

Its inserted the two new rows at the bottom of their Sources.

[Parthasarathi]

Great, that works as expected

[Parthasarathi]

Hi, 

Could you please let me know how to write this updated data into the same excel sheet without creating a duplicate or deleting the current sheet.

[IraWatt]

@Parthasarathi so do you want a new sheet created with all the added data?

[Parthasarathi]

 No, I want to update the same sheet, not creating a new sheet.

[IraWatt]

Ah that's alright, if you use an output data tool and select your Excel file there is an option here to overwrite just the sheet: