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

Polls
We’re dying to get your help in determining what the new profile picture frame should be this Halloween. Cast your vote and help us haunt the Community with the best spooky character.
Don’t ghost us—pick your favorite now!
Labels