Match values in different columns using the whole column

[Travis_Ratliff]

Hello All,

I have a problem similar to: Solved: Betreff: Compare columns in 2 sheets and highlight... - Alteryx Community

The difference in mine is that I want the values to be compared across the entire column and not just their row. 

Using the solution in this problem as an example the "2" in Column A Row 3 would not be highlighted as it has a match in Column B just not in its corresponding row.

@grossal 

Thanks

[grossal]

Hi @Travis_Ratliff,

I wouldn't call myself an expert in reporting tools, therefore, my workaround would happen outside of the reporting tools.

I'd use a RecordID tool to number every row and afterward use an Append Fields tool to build all possible combinations. First filter down to all combinations where the RecordID is not the same on both sides. Afterward, you can identify all columns that have at least one match in the other column and flag those with 1 in an additional field. This field can then be used for conditional formatting in the Table Tool. 

Disclaimer: I wouldn't use that approach if you have a lot of rows. In the case of 10k+ Rows, I'd probably go for workarounds with Find-Replace tools.

Let me know if this helps. It would be very helpful if we'd know more about your case to provide better help.

Best

Alex

[Travis_Ratliff]

I have included a sample of my workflow. So, in the final table John Joe and Maggie would be highlighted because they have a match in the other column, but Lauren would not be highlighted 

[afv2688]

Hello @Travis_Ratliff ,

Best way would be what @grossal suggested. You don´t even need to see the rules in the end which you have been working with on the table tool.

Look at the example and let me know if that works for you.

Regards

[afv2688 · Accepted solution]

Based on your example