Start Free Trial

Alteryx Designer Desktop Discussions

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

Basic Table Tool Expression: If in current Column, Row above has the same value then hide

dlesny
8 - Asteroid

I am trying to hide repeatable values in one column. What's the best approach?

Trying to add expression in Table Tool:  If this row = previous row then text colour white. Can you please help with expression or advise on better approach?

 

So this changesSo this changesto thatto that

1 REPLY 1
CharlieS
17 - Castor
17 - Castor

@dlesny

 

A Multi-Row Formula tool can take care of this for you. For each field that you want to eliminate duplicate values, use a IF statement like this 

 

IF [Field]==[Row-1:Field] THEN null()
ELSE [Field] ENDIF

Labels
Top Solution Authors