Alteryx Designer Desktop Discussions

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

remove everthing above the row based on condition

Sshasnk
8 - Asteroid

Hi I have a dataset where I have to remove everything above name.

 

F1F2F3
LMAO Ltd Help
Corporation  
   
Name Last name
   
Leo Messi
   
Cristiano Ronaldo
Robert Lewa

 

I have to remove everything above the last name (can't sample tool) It should be dynamic and also remove the null row in the above dataset

 

Output:

 

F1F2F3
Name Last name
Leo Messi
Cristiano Ronaldo
Robert Lewa
2 REPLIES 2
gautiergodard
13 - Pulsar

hey @Sshasnk 

Please see attached for one way to do this!

 

binuacs
21 - Polaris

@Sshasnk One way of doing this

 

binuacs_0-1666812708793.png

 

Labels
Top Solution Authors