Remove columns not needed

[samxhander09]

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.

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!

[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.