Alteryx Designer

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

Delete Rows based on a specific condition

Highlighted
6 - Meteoroid

Hi All,

 

Hope you are doing good....I am trying to delete  specific rows based on condition...

To be more elaborate....if a value in the country field is blank then I want to delete the entire row...Can you please let me know how to achieve the same...specific nodes/formulas to use..

 

Thanks,

Arun

Highlighted
Alteryx Partner

Hi,

 

You just need a filter tool

 

[Country]!=""

 

or with the Simple Filter:  Country    "Is Not Empty" in the dropdown

 

and the non-blanks will come out the T side.

 

( I make it a best practice to have the records I want always come out the T side, one less thing to think about :-)

 

Cheers,
Bob

 

Highlighted
14 - Magnetar
14 - Magnetar

You'll likely want to use the Filter tool.

 

Formula will depend on whether the Country field is Null or blank...

 

Null: Use the Basic Filter and choose "Country" as your field from the first drop-down, then "Is Not Null" from the second drop-down

Empty: Use the Basic Filter and choose "Country" as your field from the first drop-down, then "Is Not Empty" from the second drop-down

 

Then you'll just use the results from the True branch of the filter! Thanks!

 

NJ

Labels