Hi All, I want to create a column ,sequential code starting C001,C002 and so on for every unique entry of column workschedule code . Workschedule Codesequential codeC5700001C001C5700001C001C5700001C001C5700001C001C5700001C001C5700001C001C5700001C001C2000401C002C2000401C002C2000401C002C2000401C002C2000401C002C2000401C002C2000401C002C6000001C003C6000001C003 Can someone please help me with this.I am quite new to Alteryx and any help is greatly appreciated.

Create a sequence column (e.g C001,C002 and so on) for every unique row

Hi All,

I want to create a column ,sequential code starting C001,C002 and so on for every unique entry of column workschedule code .

Workschedule Code	sequential code
C5700001	C001
C5700001	C001
C5700001	C001
C5700001	C001
C5700001	C001
C5700001	C001
C5700001	C001
C2000401	C002
C2000401	C002
C2000401	C002
C2000401	C002
C2000401	C002
C2000401	C002
C2000401	C002
C6000001	C003
C6000001	C003

Can someone please help me with this.I am quite new to Alteryx and any help is greatly appreciated.

Expression

Accepted answers

flying008

Hi, @Learner_Kat

Maybe you like this easy way.

录制_2023_08_04_08_02_53_684.gif

All comments

Amy_smart

Hi,

You can use the multi-row tool to do this.

Please refer to this blog post and view the 'Create Unique ID For Each Person in the Group' section.

If this works for you, please choose this as an accepted solution.

Thanks,

Amy

Learner_Kat

Would you please explain how to use the multi row tool. I am new to all this

Yoshiro_Fujimori

@Learner_Kat

Yes, Multi-Row Formula tool would be a straight-forward solution.

Sample workflow

Expression in Multi-Row Formula tool

IF [Row-1:Workschedule Code] != [Workschedule Code]
THEN [Row-1:SeqNo] + 1
ELSE [Row-1:SeqNo]
ENDIF

SeqNo.yxmd

Yoshiro_Fujimori

Additional resources for your reference.

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Knowledge-Base/Tool-Mastery-Multi-Row-Formula/ta-p/86603

https://community.alteryx.com/t5/Interactive-Lessons/Multi-Row-Formula/ta-p/82872

Amy_smart

Hi,

Please follow these steps:

1)On the Create New Field, type in 'sequential code'.

2) Next Num of Rows should be 1 and Values for Rows that Don't exist should be 0 or Empty

3) Group by 'Workschedule Code'

4) In the expression box type in '[Row-1 : sequential code']+1

5) Run the workflow

6) Use the formula tool and select your column and change it to a string. Enter the formula 'C' + [sequential code]

Thanks,

Amy

flying008

Hi, @Learner_Kat

Maybe you like this easy way.

录制_2023_08_04_08_02_53_684.gif

binu_acs

@Learner_Kat Another method

joinMultipleQuestion.yxmd

grazitti_sapna

Hi Learner_Kat

you can try this way.

Thanks!

Create a sequence.yxzp

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703