Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Generate ID based on chaning dimension

Yury_Brunt
7 - Meteor

Hello,

 

I need to generate an ID based on the changing status, like in the example below.

Each ID must be based on a fixed text including the first date-time field when the status changes. 

Anyone an idea how to do that?

 

13-Mar-18 09-50-18.png

 

 

4 REPLIES 4
LordNeilLord
15 - Aurora

Hey @Yury_Brunt

 

Multirow again for this one! Read up about Multirow, it's super powerful :)

 

MultirowID.PNG

 

@LordNeilLord

Part time Tableau, Part Time Alteryx. Full Time Awesome


Data Lover

BenMoss
ACE Emeritus
ACE Emeritus

@LordNeilLord am I right in thinking the data needs to be sorted prior to the multi-row else this may cause issues?

 

Ben

LordNeilLord
15 - Aurora

@BenMoss I would have thought so. Looking at the example provided by @Yury_Brunt the data already seems to be in the correct order

 

@LordNeilLord

Part time Tableau, Part Time Alteryx. Full Time Awesome


Data Lover

Yury_Brunt
7 - Meteor

Perfect! Thanks again for your help!

Labels