Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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