Delete column.

I am very new with Alteryx. I want to delete column(s). I don't care what is in them what the headers are etc. I just want to delete a column(s). This was easy in Watson Analytics so I'd think it would be in designer but I've spent a lot of time and I don't see a way to easily just delete a column. I'm guessing the best thing to do is just remove it from the original input data set?

Thank You.

Workflow

Transformation

Accepted answers

Thableaus

Hi @sweattej

Just use the Select Tool and uncheck your desired column.

It's as simple as that.

Cheers,

All comments

Thableaus

Hi @sweattej

Just use the Select Tool and uncheck your desired column.

It's as simple as that.

Cheers,

sweattej

I knew it had to be simple. I just didn't look under the select rock. Having a Gee Duhhh moment 🙂 Thanks.

sgupta

What if there are 250+ columns? If want only 20-30 columns of the entire data. I know I can use the select tool to do it. Is there an easier way to do than unchecking 200 columns one by one?

chadirino

What if you need to dynamically delete the first column? For example, for a macro input, how would you go about making sure to always delete the first column -- say the column name might different each time?

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335