Calling all Alteryx customers: Refer your colleague to try Alteryx and receive a $50 gift card. Sign up now!
Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Column metrics difference one file to another

faisal9999
8 - Asteroid

Hi , I have data in two files containing 100 column each....I want to get difference dynamically 

 

eg.. two file A and B

 

column1 - column1 

column2 - column2

 

 

I'll have to write every column name manually in formula tool

6 REPLIES 6
Raj
16 - Nebula

@faisal9999 
find the workflow attached
mark done if solved.

faisal9999
8 - Asteroid

thanks for sharing but this was for one column suppose you have 100 column in both inputs total column 200 and and if you make difference of every column that means you have to apply 100 formula that means total column will be 300...I am looing for dymanic solution I want to save my time writing code in formula tool. 

Qiu
21 - Polaris
21 - Polaris

@faisal9999 
The workflow shared by @Raj is dynamic I believe.

faisal9999
8 - Asteroid

I understand, I am looking for something like without using formula tool if you have 100 columns for bringing differences that you have to write 100 times that formula A - B..is there anything that I can save my time writing formula 100 times.

Raj
16 - Nebula

@faisal9999 
can you share the sample input and desired output.

faisal9999
8 - Asteroid

This attached

Labels
Top Solution Authors