Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

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

Different Colors for Different Column Headers

dattina2287
8 - Asteroid

hi, i am new to Alteryx and wondering if it's possible to have different colors for different columns? Below is what i'm trying to achieve. However, I think the default table settings only lets you have one color for all headers. I tried deselecting the two columns i want in yellow and using the Default Table Settings Style Editor to make all others grey and then selecting only those 2 columns and and using the Default Table Settings Style Editor to make them yellow but it keeps overriding it. 

 

Does anyone know if it's possible to achieve the below in Alteryx?

 

dattina2287_0-1655933162541.png

 

Thanks!

6 REPLIES 6
DataNath
17 - Castor
17 - Castor

Hey @dattina2287 you can set individual colours for each header by using the following steps in the Table tool configuration:

 

Change individual header colours.png

 

Outcome:

 

DataNath_0-1655934173640.png

 

These will also override the default so you can still set the colour for the others in Default Table Settings.

 

EDIT: If you want this for the whole column and not just the header, select 'to Header and Data' in the dropdown:

 

DataNath_0-1655934587040.png

 

IraWatt
17 - Castor
17 - Castor

Hey @dattina2287,

Definitely is possible. I don't know of an easier way than this:

IraWatt_1-1655934423620.png

The tables are HTML so you can use a formula tool to changed them around a bit but it is quite clunky:

  

IraWatt_0-1655934185537.png

Any questions or issues please ask :)
HTH!
Ira

 

grazitti_sapna
17 - Castor

Hi @dattina2287, you can use reporting tools in this scenario. Use a basic table tool then select the columns for which you want to specify a color and create a column rule.

 

grazitti_sapna_1-1655955367345.png

 

 

grazitti_sapna_0-1655955327377.png

grazitti_sapna_0-1655955490605.png

 

 

In order to save this output, you can use a render tool and save it as an excel.

 

I hope this helps!

 

Thanks!

 

Sapna Gupta
dattina2287
8 - Asteroid

@DataNath as always, this worked perfectly!! Thank you so much!

dattina2287
8 - Asteroid

thanks @grazitti_sapna ! The Header Column Only was the key here so this worked perfectly!

gupta_sahil
8 - Asteroid

I am getting inconsistent results when AMP engine is turned off vs turned on. When AMP engine is turned on the above workflow does not change color of header background but of data background, while AMP is off its working perfectly fine. Is there any way we can get consistent results whether AMP is off or on? I see this issue is mainly on latest version of alteryx (Version: 2022.3.1.395).

 

gupta_sahil_0-1678096906675.png

above results when AMP is off.

 

gupta_sahil_1-1678096958957.png

above results when AMP is on.

Labels