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!
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.