When connecting two files, how can I easily move columns together based on Column name?

Hi everyone,

I am in need of some help. I have two outputs, and I want to join them together and dynamically move columns next to one another based on matching column headers. In this example, the column headers are dates. Is there a way to do this with a large data set without having to use the select tool each time?

Thanks!

Accepted answers

All comments

Emil_Kos

Hi @deckthehalls,

Please disregard 🙂 I misunderstand your question.

Emil_Kos

Hi @deckthehalls,

I initially thought that you want to union the data.

To sort the data by columns you will need to use crew macro:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/How-do-I-automatically-Order-Columns/m-p/35640/highlight/true#M14140

For example this:

Will become this:

You need to keep in mind you can't have exactly the same columns in one file so you will need to add something to your date. Event invisible space will do it.

So for example one column needs to be named "1-jun" and the second "1-jun ".

I hope this helps.

mceleavey

Hi @deckthehalls ,

Use the transpose tool, grouping by state column.

Union both together, sort by name, then crosstab, grouping by the state, using name as name and value as value.

If you want to post your data I can build it for you.

deckthehalls

Hi @mceleavey,

Can you select more than one value using the cross tab tool? right now, I only see the option to select one value.

Thank you for your response!

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15880

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703