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.
@siiddd would you be able to provide some sample input file and expected output result
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.
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.
This was what I was looking for. Thank you :)