Matching columns
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Labels:
- Designer Cloud
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
