Different Colors for Different Column Headers

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?

Thanks!

Best Practices

Accepted answers

DataNath

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:

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:

grazitti_sapna

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.

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

I hope this helps!

Thanks!

dattina2287_workflow.yxmd

All comments

DataNath

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:

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:

IraWatt

Hey @dattina2287,

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

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

Any questions or issues please ask
HTH!
Ira

Workflow.yxmd

grazitti_sapna

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.

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

I hope this helps!

Thanks!

dattina2287_workflow.yxmd

dattina2287

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

dattina2287

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

gupta_sahil

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).

above results when AMP is off.

above results when AMP is on.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703