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