In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!
community Alteryx IO MyAlteryx
alteryx Community
Search
This Board
  • Global Community
  • This Category
  • This Board
  • Knowledge
  • Users
 cancel
Turn on suggestions
Showing results for 
Search instead for 
Did you mean: 
Close
Free Trial

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
‎10-26-2022 11:56 AM

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
Reply
2 REPLIES 2
gautiergodard
13 - Pulsar
‎10-26-2022 12:29 PM

hey @Sshasnk 

Please see attached for one way to do this!

 

sort.yxmd
Reply
binuacs
21 - Polaris
‎10-26-2022 12:31 PM

@Sshasnk One way of doing this

 

binuacs_0-1666812708793.png

 

remove_fiels_1026.yxmd
Reply
0 Likes
Find a local User Group
designer new user guide
Labels
Top Solution Authors
View All