Filter columns based on a condition

[siiddd]

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.

[binu_acs]

@siiddd would you be able to provide some sample input file and expected output result

[siiddd]

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.

[gawa · Accepted solution]

@siiddd 

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.

[siiddd]

This was what I was looking for. Thank you :)