Hi All!,
I have been trying to utilize Alteryx to do what I have done in the same attached report. I have been able to get the top color red and grey.
My Question is:
1.) How can I get the gridlines for certain sections of the report with two blank rows between each section.
2.) Is there a way to only have the red color the first 9 columns on the first row?
Thank you so much!
Solved! Go to Solution.
Hello @rgalik,
1) For the separation I think the easiest way would be to do a union by position with a manual input with two empty lines.
2) For the second part I think you could only achieve it manually editing per column on the table tool. Can't think right now of doing it anoter way
Regards
Hi!
Thanks! I have done the union tool. But when I export to Excel, there are no black lines on each sheet.
Any advice on how to do this?
Hello @rgalik ,
Do you mean that the lines were before but not now anymore?
Did you union the empty lines on a separate table tool or directly before data goes into the table tool?
Regards
Hi,
The lines were never there. I need to add them. Perhaps I should clarify, by gridlines, I mean it to look like the gridlines when they are outlined in black. My export has no outlines around each individual cell per each section.
Yes, here is a screenshot of the flow.
I need borders around each cell in each section.
Hi,
Not quite. I need the borders to be around field 1 and then all the cells under it. As well as the the other cells. But no thick outside borders.
I have also tried to format the columns where the column contains a certain words, but it doesn't seem to take.
Thank you so much!
This works perfectly!!
Can this be exported to Excel?