This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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..
You just need a filter tool
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 :-)
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!