We have extended our Early Bird Tickets for Inspire 2023! Discounted pricing goes until February 24th. Save your spot!

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer and Intelligence Suite.

Append records in Excel and Increment the last ID by 1

jayross2408
5 - Atom

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

 

IDTest Field
1Test1
2Test2
3Test3
4Test4

 

New Data to be appended in Target File

 

Test Field
Test5
Test6
Test7

 

Final Output

 

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

 

Hope you could help me. Thanks!

3 REPLIES 3
Alteryx_AR
12 - Quasar

@jayross2408 -Hope this helps --

 

ArtiRajput_0-1641396280109.png

ArtiRajput_2-1641396364655.png

 

 

binuacs
17 - Castor

@jayross2408 One way of doing this

 

binuacs_0-1668721471051.png

 

DenisZ
11 - Bolide

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. 

Labels