Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
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