How to set Column Order

[Mukeshy12390]

Hello Everyone - 

I have been trying to build solution which can decide column order on the basis of Mapping.

Example : -  I have Excel file with 150 headers and these headers come in random order everytime.

I wanted to decide these order on the basis of mapping. so that later user can change order according to their need.

I don't want to use CorssTab/Transpose function.. reason 1) it replaces all  special Char to "_" and changes data type to text.

these are reason I affraid to use it.

Is there any other possible solution or workaround for this issue.

any help would be appreciated.

Thanks

Mukesh Y

[JosephSerpis · Accepted solution]

Hi @Mukeshy12390 I mocked up a workflow that shows an approach I use when I have a similar challenge. Let me know what you think? 

[Mukeshy12390]

Perfect ! works for me.

Thank you so much for the quick reply.

[wwatson]

Would a Select tool not work for this situation? In that tool you can set the order of the columns.

[JosephSerpis]

The select tool order can change automatically depending on your workflow e.g. so you may lose the order. This may happens in cases where you have macros and tools from the transform category. You can use a configuration file from the select tool however that might not be as transparent and easy to update than a mapping table. Like most things with Alteryx you can solve a problem in different ways. I like this approach as it easy to understand and update and the order is locked so doesn't change dynamically.