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

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE
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