Alteryx Designer Desktop Discussions

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

Indenting row using the Table Tool

brad_j_crep
8 - Asteroid

I have a report where I'd like to indent the rows where the first column is the same number.  Something like this.

 

1234

1234

1234

5678

5678

5678

 

I'd like it to look like this:

 

1234

    1234

    1234

5678

     5678

     5678

 

Is it possible to do this in the table tool or using another set of tools?

 

Thanks,

1 REPLY 1
Federica_FF
11 - Bolide

Let's say your column is named [Column1], use a multi row formula and create a new field named [Column 2]

 

IF [Column1]=[Row-1:Column1] then [Column1]

else null()

endif

Labels