Column Arrangement

[Learner09]

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  

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

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

[Qiu · Accepted solution]

@Learner09 

Added a filter and replaced the underscore with space

[Learner09]

@Qiu Thanks alot!