cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Discover peer insights or crowdsource your one of a kind Designer question.

Generate ID based on chaning dimension

SOLVED
Highlighted
Meteoroid

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

 

 

Alteryx Certified Partner

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

Alteryx Certified Partner

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

 

Ben

Alteryx Certified Partner

@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

Meteoroid

Perfect! Thanks again for your help!