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!

Alteryx Designer Desktop Discussions

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

How to delete columns based on criteria in column title

FionnGodwin
5 - Atom

I want to delete columns in my table based on the name of the column. There are lots of columns with names like: accountgroup1, accountgroup2, accountgroup3....i want to removed these. 

 

Trying to use the Dynamic Select tool with the function !StartsWith(column, "accountgroup").

 

How can i get a formula to run through all the columns and deselect the ones that start with "accountgroup"?

2 REPLIES 2
kenkie
6 - Meteoroid

Hello Fionn, can you try this one? !StartsWith([Name], 'accountgroup')

kenkie_0-1636391104183.png

 

benholland
5 - Atom

I had the same issue, and used your solution @kenkie which worked. So although you don't have a reply from FionnGodwin, just wanted to say your solution is correct and works. Thanks 👍

Labels
Top Solution Authors