Alteryx Designer Desktop Discussions

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

column difference dynamic without using formula tool

faisal9999
7 - Meteor

I have date two filess same column name in both file I want differnece A - B for each column but I need a solution without using formula tool because using formula tool I will need to manually write column A - column B. I want it dynamically that will help me if I have more than 50 columns in my file. sample screenshot is attached

2 REPLIES 2
Mathias_Nielsen
8 - Asteroid

HI @faisal9999 ,

 

Hope this works with your data :)

Mathias_Nielsen
8 - Asteroid

This assumes that data is in the correct order and a RecordID can be used. If you have an identifier between the two dataset please use this instead of RecordID :D

Labels