Different Colors for Different Column Headers

[dattina2287]

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!

[DataNath · Accepted solution]

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

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

[grazitti_sapna · Accepted solution]

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]

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