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

[Fescobar]

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

[CharlieS]

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(<String>,<Length>)'. 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.