We have extended our Early Bird Tickets for Inspire 2023! Discounted pricing goes until February 24th. Save your spot!

Alteryx Designer Discussions

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

How to compare multiples column values

BattleBat
5 - Atom

Hi, 

 

Below is what I am trying to do, any idea is appreciated!

 

Input File 1: 

Column AColumn B
a01d04
b02e05
c03f06

 

Input File 2:

Column AColumn B
a01d04
b02e005
g07h08

 

Input File 3:

Column AColumn B
a01d04
b02e05
g07h08
i09j10

 

Output file:

Column A-1Column A-2Column A-3Validation-Column AColumn B-1Column B-2Column B-3Validation-Column B
a01a01a01TRUEd04d04d04TRUE
b02b02b02FALSEe05e005e05FALSE
c03  FALSEf06  TRUE
 g07g07FALSE h08h08TRUE
  i09FALSE  j10TRUE

 

In the output file, I need to compare the columnA-1,A-2&A-3, taking the nulls into account, only exact match should return "TRUE", for ColumnB-1,B-2&B-3, I need to ignore nulls. 

 

Thank you in advance! L 

4 REPLIES 4
pedrodrfaria
13 - Pulsar

Hi @BattleBat 

 

See attached for the WF below:

 

pedrodrfaria_0-1615984008613.png

 

 

Pedro.

mceleavey
17 - Castor
17 - Castor

Hi @BattleBat ,

 

I've used the pivoting tools to hopefully future-proof this.

 

mceleavey_0-1615985036161.png

 

mceleavey_1-1615985065711.png

M.

 



Bulien

BattleBat
5 - Atom

Thank you very much, this works! 

mceleavey
17 - Castor
17 - Castor

no problem.gif



Bulien

Labels