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

dlesny

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 changesto that

CharlieS

@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