Alteryx Designer Desktop Discussions

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

Matching columns

ivoiculescu2020
8 - Asteroid

Hello team,

I need your help to figure out how to change the formula I've used to match 2 columns, I use this formula but it does not work completely; it partially shows the matches but the mismatches are not always mismatches.

 

IF(Contains([DISTRIBUTION_CENTER_CODE], [Vendor Warehouse Code])) then "MATCH" else "MISMATCH" ENDIF

 

I need Alteryx to show me ALL rows that have the same distribution code and vendor warehouse code. The distribution code is taken from our internal distribution systems and the vendor warehouse code is an information that exists on reports that we acquired from external parties. The reason I use this formula is to see if any of the supplies from the external reports already exist at the exact same locations in our internal systems;  otherwise, I need to compile a report with all the mismatches, that is all supplies that appear in our internal systems in different warehouses than on the external reports.

 

Can you please assist? Did I do something wrong in this formula and that's why it doesn't provide me with accurate information?

 

Thank you!

Kind regards,

Ioana

4 REPLIES 4
Manoj_k
9 - Comet

Replace the Contains() function with == to ensure exact matches between the two columns:
IF([DISTRIBUTION_CENTER_CODE] == [Vendor Warehouse Code]) THEN "MATCH" ELSE "MISMATCH" ENDIF

ivoiculescu2020
8 - Asteroid

@Manoj_k 

Hello,

unfortunately it still works partially. I don't know why but the formula does not look in the entire column vendor warehouse code. it only looks at the cell.

For example, it finds matches only if the same warehouse code is found on the same row. However, if the same warehouse code appears in different rows, it shows mismatch most of the time. Any idea how I can ask Alteryx to look in the ENTIRE vendor warehouse code column and compare it to the ENTIRE distribution code column and show the matches/mismatches?

 

Thank you for your help!

Kind regards,

Ioana

dwstada
11 - Bolide

use the join tool and join both columns with each other to get pairs of different rows that would match (probably need to add something like a material number as well)

 

the filter tool only does row wise operations

danilang
19 - Altair
19 - Altair

Hi @ivoiculescu2020 

 

Can you provide some anonymized sample data as well as the output(both matched and unmatched) that you're looking for.  Without sample data there are too many ambiguities for us to provide a solution. 

 

Dan

Labels
Top Solution Authors