Alteryx Designer Desktop Discussions

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

Assign an incrementing ID value

Deano478
11 - Bolide

Hi guys,

 

I have data like so:

ReturnTypeReturnStatus
CRSent
CRNot Yet Sent
CRReceived
CBSubmitted
CBIn Progress
CBSent
CTRejected
CTReturn Filed
CTRefund Pending
CTNew Info needed
CTRejected

 

What Im trying to do is assign a group ID to each Return Type. I've tried a few different methods but sadly no dice.

 

The output I'm trying to achieve looks like so:

 

IDReturnTypeReturnStatus
1CRSent
1CRNot Yet Sent
1CRReceived
2CBSubmitted
2CBIn Progress
2CBSent
3CTRejected
3CTReturn Filed
3CTRefund Pending
3CTNew Info needed
3CTRejected

 

 

Many thanks in advance

4 REPLIES 4
messi007
15 - Aurora
15 - Aurora

@Deano478,

 

Please see below how you can do that.

Capture.PNG

 

Attached the workflow,

Regards

Deano478
11 - Bolide

@messi007  many thanks, I see what you did there i was just completely over thinking how to do it.

messi007
15 - Aurora
15 - Aurora

@Deano478,

 

Happy to help!

 

Regards,

binuacs
20 - Arcturus

@Deano478 Another option is use the tile tool

image.png

Labels