Filter columns based on a condition
- 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 have simplified my problem as simple as possible. Any help is much appreciated guys :)
I have 2 excel files A and B.
A has columns X, Y and Z.
B has columns X, Y.
I want to create an Alteryx Workflow that picks up the common columns between A and B and create C with values for X and Y.
Note: (The Values for X and Y in C must be from A)
Basically, I am trying to use the columns names in B as filter for the columns to be displayed in A.
Solved! Go to Solution.
- Labels:
- Join
- Transformation
- Workflow
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@siiddd would you be able to provide some sample input file and expected output result
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Sure. Please find the files attached.
Now A has the columns - Name, Maths, Physics and Chemistry.
B has the columns - Maths and Physics.
Now what I want to implement is that, Since B has only columns Maths and Physics. A should be made to display only Maths and Physics columns.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Here is my solution. Trick herein is to first transpose both data into vertical shape, and join(to filter corresponding header name), and revert to horizontal shape by cross-tab. I put Record ID so that original order can e retrieved at the end of process.
For your reference, I attach yxzp.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
This was what I was looking for. Thank you :)
![](/skins/images/6056C79A596CAB15526D64C598622101/responsive_peak/images/icon_anonymous_message.png)