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

[df]

Hello alteryx community,

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?

[LordNeilLord · Accepted solution]

Hey @df

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

@LordNeilLord

Part time Tableau, Part Time Alteryx. Full Time Awesome

[BenMoss · Accepted solution]

Here's a solution.

Ben

[AndyBate · Accepted solution]

This may help

[df]

@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 :)