Union Tool - How to stack data by column, instead of row
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I need to combine multiple Excel files. All of them have the same format. The rows contain survey questions. Same survey questions in all files. The column contains entity name. When I use the Union tool, it stacks the data in rows, ie. data rows for File A is followed by data rows of File B. So the survey questions are repeated many times But I want the data to be stacked in column by entity name. Please see the attached sample file. Please help to see if you could kindly give me a solution.
Solved! Go to Solution.
- Labels:
- Workflow
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I suggest also to add some RowIDs to your questions so it's easier to join them as a primary key than the full question itself. Sometimes the questions can be phrased slightly differently or a spelling error or some inconsistent whitespace exists.
Hope this helps @HSCUBS - if it does, kindly leave a like and mark my reply as the accepted solution so that others may benefit as well + to close the thread accordingly.
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks for your prompt reply. As I have more than 2 files, I have copied your workflow and used Multiple Join. Thanks again.
![](/skins/images/9AF25434D4F136B28264A96CA92E8A93/responsive_peak/images/icon_anonymous_message.png)