Community Halloween is live until October 31st! Complete any 2 quick activities to earn the 2025 Community Halloween badge. Feeling brave? Check out the activities here
Start Free Trial

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
8 - Asteroid

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
9 - Comet

HI @faisal9999 ,

 

Hope this works with your data :)

Mathias_Nielsen
9 - Comet

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
Top Solution Authors