Column Arrangement

Hello All,

I am working on an Alteryx Model in which I have an Input file that contains around 400 columns and 30k Rows data. In the flow, I have further added some new columns as per analysis requirements (I have added 18 new columns through formulae). At the end of the flow, I have a total of 418 columns and I just need only 118 columns in my output (100 out of the 400 that is from input file and 18 my new added columns) that too in specific sequences. I just wanted these 118 columns appearing on the top 1-118 in the select tool and the rest 300 columns following these 118. So please assist me if there is any way which I can arrange these without manual efforts. Please see the details in the attached file.

Thanks,

Mayank

Example1.xlsx

Help

Accepted answers

Qiu

@Learner09

Added a filter and replaced the underscore with space

0210-Mayank09.yxmd

All comments

Qiu

@Learner09
Hope you like this one.

Since you want things to be specific order, so we have to face the fact that some manual work will be involved.

To that end, a input file with the columns names and order sequence should be in place.

I add string like "001ZZZ001ZZZ" to make sure it will not be part of your input column names so I can replace them later.

0210-Mayank09.yxmd

Learner09

Hello, @Qiu Thank you so much!! it's worked. The only thing is the header Name appearing with underscore _, so can you add a tool in the flow that removes these underscore. Also, is it that possible in the output sheet I can only extract my 118 columns?. Please advise

Please see the attached file for the details

Cheers!

Example2.xlsx

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703