Start Free Trial

Alteryx Designer Desktop Discussions

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

Formula tool with multiple expressions validating multiple columns

EricMartinson
7 - Meteor

Hello,

 

I am comparing data from two versions of the same report to identify the differences so I know which records have columns that need to be corrected. I am using a Formula tool with eight expressions to validate four sets of data and arrange the output messages. This solution works but I have two questions.

 

  1. Is there a more efficient way I could have done this?
  2. This formula tool is only validating January data but I need to do the same for all other months. Is there a way to dynamically run for all the other months without recreating this same formula tool for each specific month?

 

EricMartinson_0-1648615965349.png

EricMartinson_1-1648615977771.pngEricMartinson_2-1648615989811.png

 

3 REPLIES 3
JarekSkudrzyk
11 - Bolide

@EricMartinson 

hi,

you can transpose the data and then compare a single column - i think it is quicker (my solution attached).

JarekSkudrzyk_0-1648619305813.png

 

EricMartinson
7 - Meteor

Thank you @JarekSkudrzyk! This approach worked perfectly. 

JarekSkudrzyk
11 - Bolide

@EricMartinson you are welcome, glad I could help!

Labels
Top Solution Authors