Identify if every column and row contains the same data

Hello everyone,

Without going into great detail of my workflow I created a table that will contain the same amount of columns (1-24), but the row count will change. The data per column down every row should contain the same string.

Can you please help me in the best way for Alteryx to read each column and give me a true/false and return the incorrect string.

ie. in my attached example column F3 has an incorrect string in RecordID 3.

Example

Thanks everyone.

Datasets

Accepted answers

tom_montpool

After my last answer I visited a KB post about the Tile tool (https://community.alteryx.com/t5/Alteryx-Knowledge-Base/Tool-Mastery-Tile/ta-p/30235) which gave me an idea for another approach.

Use the Unique Value option in the Tile tool (select all your fields that you want to be unique)

Filter out where Tile_Num isn't 1 and Tile_SequenceNum is 1 and you get a nice list of each non-unique value

I've updated my previous workflow...

01_Identify_all_the_same_v2.yxmd

All comments

KaneG

Hi @Domo,

How would you determine what they had to match? Would they have to match the first row?

You can use a summarize tool to get all rows that differ. If you change your RecordID to String, then you can concatenate those...

In the attached Module, there is 2 different options depending on whether your happy with still having human intervention. Solution 1 could be automated to report and fix, whereas Solution 2 will just give you the lines...