How to retain the last incremented Record ID value for the incremental load

Hi team,

I am using the Record ID to create the sequence generator, by setting the initial value. This we are using as a unique key for inserting records to table.

But the problem is each time the workflow runs the same Record ID value is creating, I want the value to be changed each time the workflow runs. means

if the workflow runs 1st time for 10 records then the last Record ID value is 10. when the second time same workflows runs for the different set of records

then Record ID should start from 11 onwwards..

Please guide me how to achieve this.

Regard

SMANE

Common Use Cases

Accepted answers

DataPrepChad

Check out the attached. Personally, I'd first try to determine the max RecordID from the existing database, then append that to your new data stream. If you create another new recordID that begins incrementing from 1, you then just simply add that to the max RecordID from the old set.

IncrementRecordIDFromOldMaxID.yxmd_.png

Hope this helps!

~ Chad

dataprepu.com

IncrementRecordIDFromOldMaxID.yxmd

All comments

LordNeilLord

Hey @SMANE

When the workflow runs again, how do you know that it's the second time of running? Is the last value of the recordID stored or re-inputted into the workflow?

SMANE

Hi LordNeilLord

Thanks for you reply, Presently I have put the Record ID initial value = 1 in the designer workflow,Which is used as unique key for inserting the records into the target table. this workflow will run as and when data needs to be loaded to target table.

Each time we run the workflow ,we need the Record ID to be incremented not from the initial value set-up but from last run max record ID. Since I am new to Alteryx might not finding the right approach.

Need help on this :-)

DataPrepChad

IncrementRecordIDFromOldMaxID.yxmd_.png

Hope this helps!

~ Chad

dataprepu.com

IncrementRecordIDFromOldMaxID.yxmd

SMANE

hi Chad,

Thanks for the solution, As in other tool eg. Informatica has the sequence generator, Which hold the last highest value of seq and next time you run the

workflow it automatically increments from the last value. I was thinking the same way in Alteryx too. But anyhow this works.

Thanks

SMANE

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703