Start Free Trial

Alteryx Designer Desktop Discussions

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

Empty Rows Between Tables

Cfdiaz2103
8 - Asteroid

Hi Guys!

 

Does anyone know how I could create empty rows between different tables united by an Unite Tool? Every table was designed by a Table Tool to be rendered later on.

 

Example, Suppose the first table is the Blue-coloured, while the second one is Red-coloured.

 

ClientProductQPrice/UnitTotal
AC1510,0050,00
BC248,0032,00
ClientProductQPrice/UnitTotal
CC373,0021,00
DC482,0016,00

 

Now, What I need to do is to separate both tables by an empty row,  just like this:

 

ClientProductQPrice/UnitTotal
AC1510,0050,00
BC248,0032,00
     
ClientProductQPrice/UnitTotal
CC373,0021,00
DC482,0016,00

 

I'd appreciate any support.

 

Thanks!

5 REPLIES 5
mceleavey
17 - Castor
17 - Castor

Hi @Cfdiaz2103 ,

 

Are you wanting to separate the data in the normal data workflow, or render the tables with a divider in the reporting tools?

 

 



Bulien

Cfdiaz2103
8 - Asteroid

Hi @mceleavey!

 

I would like to render all the tables with a separator with the set of the reporting tools

mceleavey
17 - Castor
17 - Castor

@Cfdiaz2103 ,

 

I've built the data so it represents the different tables, as I don't have access to how your data looks. So, I have two inputs, one for each table. I have then given each one a table number, obviously you can make this dynamic depending on what your raw data looks like.

 

mceleavey_0-1638388452401.png

 

I have then unioned the data together so it looks like this:

 

mceleavey_1-1638388480045.png

 

I then simply used the table tool but applied the group by function to create a new table based on each Table ID:

 

mceleavey_2-1638388516577.png

 

Then used the layout tool to create the final appearance of the tables:

 

mceleavey_3-1638388548356.png

 

I've attached the workflow.

 

I hope this helps,

 

M.

 

 



Bulien

Jonathan-Sherman
15 - Aurora
15 - Aurora

Great solution @mceleavey!

mceleavey
17 - Castor
17 - Castor

Thanks @Jonathan-Sherman  🙂



Bulien

Labels
Top Solution Authors