Table-1
X | Y | Z | Count(T) | |
001 | T | T | F | 2 |
002 | F | T | F | 1 |
003 | F | F | F | 0 |
004 | T | T | T | 3 |
I am new to Alteryx and looking for Count(T) column as a result. Same Count(T) from table-2.
Table-2
X | Y | Z | Count(T) | |
001 | T | T | F | 2 |
002 | T | F | T | 1 |
003 | F | F | F | 0 |
004 | T | T | F | 2 |
Also highlight if there is a mismatch in count(row wise). Table size and columns are fixed.
Result:
Account | X/Y/Z | Table-1 | Table-2 |
004 | Z | T | F |
Solved! Go to Solution.
Take a look at the attached workflow:
The table 1 and table 2 containers are the same:
To compare, join the transposed data together based on ID and column name, and then filter anywhere where the Table 1 value != the Table 2 value
My solution is a little bit more complex as I am using more tool but the logic is very similar to the solution build by @Luke_C
Output
I see two differences not only in ID 4 but also in the record ID 2.
Not sure if I didn't understand something correctly or in your output there is a mistake.
Thanks everyone for the solution and the effort. I have accepted the one which is very close to my use case, but thx a lot.