Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Count T/F values row wise

Table-1

 XYZCount(T)
001TTF2
002FTF1
003FFF0
004TTT3

I am new to Alteryx and looking for Count(T) column as a result. Same Count(T) from table-2.

 

Table-2

 XYZCount(T)
001TTF2
002TFT1
003FFF0
004TTF2

 

Also highlight if there is a mismatch in count(row wise). Table size and columns are fixed.

Result:

AccountX/Y/ZTable-1Table-2
004ZTF

 

4 REPLIES 4
Luke_C
17 - Castor

Hi @GauravBansal20nov 

 

Take a look at the attached workflow:

 

The table 1 and table 2 containers are the same:

  1. Transpose the data so XYZ are rows
  2. Filter to True
  3. Summarize tool to count
  4. Join the counts back to the original dataset

 

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

 

Luke_C_0-1619788845485.png

 

Emil_Kos
17 - Castor
17 - Castor

Hi @GauravBansal20nov,

 

 

 

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 

 

Emil_Kos_2-1619789188849.png

Output

 

Emil_Kos_0-1619789140511.png


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.

RaviP
8 - Asteroid

Hi @GauravBansal20nov 

 

Here's a solution slightly different @Emil_Kos  and @Luke_C 

 

RaviP_0-1619796163355.png

 

I also had disconnect in two IDs

 

Hope the solution helps

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.

Labels