We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
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