Add Spacer Row to Table Output

[CSmith16]

Working on a workflow that is for one of our end users. They want to be able to create a table for a layout / render tool in a specific format, they have added in spacer rows to their workflow and have the output looking like how they want it prior to the table tool but, after the table is created it makes the size of those rows with no data super small and basically nonexistent. I am looking for a way to add a blank row for spacing on a table on Alteryx. 

  

[griffinwelsh · Accepted solution]

@CSmith16 To my knowledge there is no intended way to do this in Alteryx, but I have a very crude workaround for this. Let me know if you need any additional help or mark solved if this handles your usecase.

1.Build your workflow and run it to render your table as normal with the render tool

2. Add a formula between the table and render tool. Update the Table field with this formula:

Replace([Table], '<cell class', '<cell height = "15px" class')

If you need to change the height you can edit the 15px part.

3.Run the workflow and ignore the fact that Alteryx thinks this is no longer a table... It will still render as we are just adding the CSS manually

[griffinwelsh]

@CSmith16 here is a macro that makes the process easier by letting you just feed in your table and configure a few parameters.

[CSmith16]

@griffinwelsh, Editing the css in the formula tool worked perfectly, thank you!