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

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.

Workflow

Accepted answers

IraWatt

Ah okay so does my setup work here:

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

Workflow.yxmd

All comments

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%20Expressions

Any questions or issues please ask

Ira Watt
Technical Consultant
Watt@Bulien.com

Workflow.yxmd

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