Append records in Excel and Increment the last ID by 1

[jayross2408]

Hi,

I have this workflow wherein when I append the data in my excel, I want to increment as well the max ID by 1.

Target File for Output

ID	Test Field
1	Test1
2	Test2
3	Test3
4	Test4

New Data to be appended in Target File

Test Field

Test5

Test6

Test7

Final Output

ID	Test Field
1	Test1
2	Test2
3	Test3
4	Test4
5	Test5
6	Test6
7	Test7

Hope you could help me. Thanks!

[Alteryx_AR]

@jayross2408 -Hope this helps --

[binuacs]

@jayross2408 One way of doing this

[DenisZ]

I would suggest unioning the data first, then use the multirow formula tool to increase the ID by 1. Select the "Update" selection in the multi-row formula tool and then the ID

[Row-1:ID]+1

 Hope it helps.