community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

is entry in column "a" before column "b"?

Asteroid

Hello alteryx community,grafik.png

 

i want to mark every action 2 when action 1(from same ID) is before in time and no other action 2 is between.

 

attached a table with testdata.

 

how can i solve the problem?

Alteryx Certified Partner

Hey @df

 

I'd use a mixture of Transpose and Multirow to get something like this:

 

RecordFlag.PNG

 

@LordNeilLord

Part time Tableau, Part Time Alteryx. Full Time Awesome


Data Lover

Alteryx Certified Partner
Alteryx Certified Partner

Here's a solution.

 

Ben

Asteroid

This may help

Highlighted
Asteroid

@LordNeilLord @AndyBate Both of your solutions are fine although there have a different approche

 

@BenMossyour solution just "flag" the first action 2 per ID - this is correct for the textfile but not for my real data

 

Thank you to all contributors and your answers - was interesting to follow your solutions. i learnd something :)

Labels