Create a Counter column in alteryx

I want to create a counter column in my table each time my workflow runs, for example, i want to start with 10001 as my first number then next time my workflow runs it changes to 10002 for the same column.

counter

10001

next time when I run the workflow it changes to

10002

please help I want to include that column in my table.

Reporting

Dynamic Processing

Accepted answers

All comments

NikyN

Hello @arsh011,

are you storing the outputs with '10001' columns somewhere? If yes, than easily just to add formula, and ToNumber(RunCount)+1 should works for your. In case that you are not storing this information anywhere, I believe you will need to create specifically for this column create tracker stored somewhere --- to track it.

Best Luck!

Niky

atcodedog05

Hi @arsh011

Also when you say it needs to start from 1001 does it need to reset everyday or something?

binu_acs

@arsh011 One option I am thinking was keep the counter in an excel file and update using a formula tool each time when you run the workflow. Keep the counter value 10001 in excel when the workflow run first time it will update to 10002 and output the updated value in the same excel

Counter.yxmd

Qiu

@arsh011
I think we can use an Excel file as a storage as below

0217-arsh011.yxzp

arsh011

thanks @Qiu but i want to append this file with the existing file with new counter number.

for eg :

sample.xlsx desired sample.xlsx

Counter Counter

1002 1002

1003

arsh011

I am also getting the error when I change the output tool configuration from overwriting file to appending to existing file .

binu_acs

@arsh011 IF you want to append the counter in your output then use an append tool and write in your output to a different file. The counter file should be keep it separate

Counter.yxmd

Quick Links

This months top contributors

AkimasaKajitani 387

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335