I created a Join on two columns and all of the data married-up accordingly. I need to be able to call out two values that are accurately joined without removing them from the sheet. In other words, I don't want to use the Unique tool to separate them. I just need them call the difference out so that the viewer is able to see it easily. In the example below the call out I would like to do is on the Retailer Desc. As you can see the join worked by matching the Corp UPC and UPC Clean columns. I'd like to be able to do some sort of formatting, highlight the cells, change the font number...anything to help distinguish them. Corp Item NbrCorp DescriptionRetailer DescCorp UPCUPC Clean142802MOLLYDOOKER CAB SV GIGGLEPOT(SC)11Mollydooker Cab Gigglepot Wine - 750 Ml933697500020933697500020244379WILD TURKEY AMER HONEY SHOT MACHMollydooker Cab Gigglepot Wine - 750 Ml933697500020933697500020910914MOLLYDOOKER VERDEL VIOLINIST(SC)17Mollydooker Verdelho Violinist Wine - 750 Ml933697500006933697500006958350MOLLYDOOKER CAB SV GIGGLEPOT(SC)18Mollydooker Cab Gigglepot Wine - 750 Ml933697500020933697500020964419MOLLYDOOKER SHIRAZ CARNIVAL LOVE18Mollydooker Carnival Of Love Shiraz Wine - 750 Ml933697500001933697500001987232MOLLYDOOKER MERLOT SCOOTER(SC)19Mollydooker The Scooter Merlot Wine - 750 Ml933697500009933697500009987394MOLLYDOOKER SHIRAZ BLUE EYED(SC)19Mollydooker Blue Eyed Boy Shiraz Wine - 750 Ml933697500030933697500030 Thank you!! FEscobar Match On Join Need Callout on Desc.png All Mats Join Joined UPCs With Unique and Dup.yxmd

Sorry I haven't had a chance to circle back sooner. The latest posts bring us back to the "fuzzy matching" topic, but if you'd like to use the string compare method above, you can absolutely do that in Alteryx. To return the first 6 characters of a string, the Left( function can be used. The syntax is 'Left( , )'. Here's an example of how you could conduct that test in Alteryx: IF Left([Corp Description],6)=Left([Retailer Desc],6) THEN 'False' ELSE 'True' ENDIF You'll notice that I swapped the True/False in my IF statement, and here's why. An expression like this can be added directly to the Table tool rule. In this case, I add two Column Rules (one for each description field) because when they don't match, I want both highlighted. When you write expressions in the Table rules, the outcome must be "True" when you want the rule/formatting to be applied. In this case, the "True" result should be given when they don't match. Here's where that expression is configured: Now the Table tool is all we need to produce this: Check out the attached workflow and let me know if that helps. 20210112-ColorDifferences.yxmd

Hello .@CharlieS and .@ArtApa Thank you for the effort folks, but I could not get Alteryx to do what I needed. I resolved it by creating a formula with conditional formatting. =IF(MID(B2,1,6)=MID(C2,1,6),TRUE,FALSE) Basically, I'm looking at the first six letters to see if they match and highlighting the cells that do match and leaving the ones that don't unformatted. I would still love to be able to do this process in Alteryx, so if you have any suggestions, please share them. Cheers!! FEscobar

Thank you .@CharlieS How can I change the mode to highlight the entries that don't match? Another big obstacle is that the names that my org uses will almost never be the same that the retailers use. This is a big obstacle, so I just need to call out the ones that WAY-OFF. Like the example above "MOLLYDOCKER" to "WILD TURKEY". Any ideas on how to skin this?

How Do I Callout a Value

Fescobar

I created a Join on two columns and all of the data married-up accordingly. I need to be able to call out two values that are accurately joined without removing them from the sheet. In other words, I don't want to use the Unique tool to separate them. I just need them call the difference out so that the viewer is able to see it easily.

In the example below the call out I would like to do is on the Retailer Desc. As you can see the join worked by matching the Corp UPC and UPC Clean columns. I'd like to be able to do some sort of formatting, highlight the cells, change the font number...anything to help distinguish them.

Corp Item Nbr	Corp Description	Retailer Desc	Corp UPC	UPC Clean
142802	MOLLYDOOKER CAB SV GIGGLEPOT(SC)11	Mollydooker Cab Gigglepot Wine - 750 Ml	933697500020	933697500020
244379	WILD TURKEY AMER HONEY SHOT MACH	Mollydooker Cab Gigglepot Wine - 750 Ml	933697500020	933697500020
910914	MOLLYDOOKER VERDEL VIOLINIST(SC)17	Mollydooker Verdelho Violinist Wine - 750 Ml	933697500006	933697500006
958350	MOLLYDOOKER CAB SV GIGGLEPOT(SC)18	Mollydooker Cab Gigglepot Wine - 750 Ml	933697500020	933697500020
964419	MOLLYDOOKER SHIRAZ CARNIVAL LOVE18	Mollydooker Carnival Of Love Shiraz Wine - 750 Ml	933697500001	933697500001
987232	MOLLYDOOKER MERLOT SCOOTER(SC)19	Mollydooker The Scooter Merlot Wine - 750 Ml	933697500009	933697500009
987394	MOLLYDOOKER SHIRAZ BLUE EYED(SC)19	Mollydooker Blue Eyed Boy Shiraz Wine - 750 Ml	933697500030	933697500030

Thank you!!

FEscobar

Match On Join Need Callout on Desc.png

All Mats Join Joined UPCs With Unique and Dup.yxmd

Output

Accepted answers

All comments

ArtApa

Hi @Fescobar - You attached a workflow without data. Would you be able to provide sample data?

Fescobar

Thank you .@ArtApa!

Copy of SGWS missing items requested from Albertsons.12152020(Working)(3)(Submitted for Content)(Brian return file)(4).xlsx

Material_Data_Puddle(01-05 Actv) (version 2).xlsx

CharlieS

Hi @Fescobar

I might approach this by highlighting the rows that contain the duplicate values in the [Retailer Desc] field. Here's how you can use some of the Reporting tools to change the fill color of duplicated values:

- Start by using a Summarize and Filter to determine which values are duplicated and need a color assigned.

- Then assign a randomized color to each value, so if you have 3 of the same value in your data, you can find all 3 more quickly. This process isn't perfect since colors could be duplicated or be very close, but it generally works alright. This could be circumvented by using a set list of color and I've included a container to show how that could be done as well.

- Build the color RGB values into the string format the Table tool can use like "rgb(194,241,253)"

- Join these values to the appropriate fields and configure a Row Rule in the Table tool to use that color value string like this:

Now your output file has the rows with non-unique values color coordinated like so:

An example workflow is attached, Let me know if this helps.

20210107-ColorDuplicates.yxmd

Fescobar

Thank you .@CharlieS

This is pretty cool stuff. My requirement is only to call out the differences in the Descriptions. Basically the Corp Description and the Retailer Description are different; however, the Corp UPC and UPC Clean are the same. therefore the union on both UPCs is accurate.

From your screenshot, I would only need the values in Row 2 to be highlighted.

Thank you SO much, again...this is cool stuff that you're sharing.

Match On Join Need Callout on Desc 2.png

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703