How to delete columns based on criteria in column title

Question

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"?

benholland · Answer

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 👍

kenkie · Answer

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