Remove columns not needed

Hi community! I have an excel file i use as an input. back when using excel, i usually just hide or delete columns i do not need. However, i wonder how i can do the same in alteryx... i tried to remove the first columns i do not need by counting how many columns they were so , i did the below.

Screenshot 2024-04-22 222753.png

But im not sure what to do with columns in the middle that i do not need. for your reference, i highlighted all columns not needed in red and attached the dummy file here. Hope you all have a good day/night!

Store ABCD.xlsx

Workflow

Preparation

Accepted answers

All comments

Raj

@samxhander09 do you have any specific logic for selecting the columns?

samxhander09

No, these are just the columns we need for reporting. Those that are needed are just deleted from the excel file.

samxhander09

@Raj but the columns not needed and those that are needed are consistent.

Raj

@samxhander09 if these columns remain consistent you can use select tool as there is on specific logic.

samxhander09

@Raj I'm wondering if there's another way to do this, without replicating how i manually do it in excel..

Raj

@samxhander09 that was the reason i asked for any specific logic.

samxhander09

That part im not sure... i can use dynamic select to eliminate the first 58 columns i don't need by basing it on the field number, but for the columns in the middle, im not sure how to make a logic for it..

bgreedy

Had a crack at a solution that uses the table names in row 1, not the most elegant way to do it deffo but hope it can help some way

The workflow creates concatenated column names from rows 1-3 so you can see what belongs to what.

Remove columns not needed.yxmd

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703