Alteryx Designer Discussions

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

How to get particular border style in Excel?

5 - Atom

I need a particular border style to be applied to headers, I have tried changing px from 1-9 but I am not getting this border style. Please see attachment for reference.

 

Border.png

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Can someone help me on this?

 

Thank you.

15 - Aurora

@Sensy2k 
So the snapshot shows the output of your workflow?

What is your desired output?

5 - Atom

@Qiu Snapshot shows the border style which I would like to apply

 

I have attached the desired output below.

 

Output_Requirement.png

Alteryx Certified Partner

Hi @Sensy2k ,

 

I came up with a workaround that might work for you. I've split the text you want to outline the box off into a separate stream and used a table tool, in the default settings of which I've changed the Table border to yes.

 

AngelosPachis_0-1610608416083.png

 

So for that single header

 

AngelosPachis_1-1610608455909.png

 

I had this output 

 

AngelosPachis_2-1610608476618.png

 

The I've joined it back to the original data and used a layout tool configured to vertical layout with section breaks, which gave me this:

 

AngelosPachis_3-1610608534530.png

Not sure if that's the kind of the thing you are after, hope it helps.

 

Regards,

 

Angelos

 

15 - Aurora

@Sensy2k 
This is the output from your workflow.

You want to border color to be black?

Qiu_0-1610608713561.png

 

5 - Atom

@AngelosPachis, thanks for trying it. If you look at both the border styles, it is not what I have asked.  From your solution, header has thick style and data has thin one (highlighted in red), I want the one which is highlighted in green.

 

Border_Highlight.png

5 - Atom

@Qiu Yes, below is the output from my workflow however it has thick border style but I am aiming for the border style highlighted in green below.  I am not bothered on border color. Thank you.

 

Border_Highlight.png

Alteryx Certified Partner

Hi @Sensy2k ,

 

Now that you know how it's done, maybe you can proceed and get familiar with it and bring it to the format/border width that is ideal for you? Personally, I struggle to see the difference between the two lines but you might have a better understanding of that.

 

Thanks,

 

Angelos

Labels