Filter columns based on a condition

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.

Workflow

Transformation

Join

Accepted answers

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.

Filter columns based on a condition_gawa.yxzp

All comments

@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.

Filter columns based on a condition_gawa.yxzp

This was what I was looking for. Thank you

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15867

MarqueeCrew 13708

apathetichell 13703