Table column heading - rule based highlighting?

[Inactive User]

Hi all,

Over the last few days I've been building a monster workflow to help with some monthly payroll reporting tasks. It's nearly finished, but I cannot for the life in me work out how to add the final cherry on top - contextual highlighting for the column headings based on their name.

See attached dummy data and picture below.

Essentially what I'm trying to do with the Table tool is:

• if column heading contains the string 'Add', then highlight that heading in a particular colour;
• if column heading contains the string 'Ded', then highlight that heading in another colour.

There will be a different number of additions and deductions each month, and each month the pay component after the 'Add/Ded' prefix is likely to change each month. I need to be able to highlight the additions headings in a different colour to the deductions headings as the table I'll be producing is huge and would be impossible to navigate without the different coloured headings.

Because the number of pay components in each category will change each month, I figured that I wouldn't be able to use a positional argument, and that I'd have to use a prefix with a 'contains' argument.

Full disclaimer, I'm still pretty much brand new to Alteryx - if you can think of a better, less goofy way to do this, I'm all ears - pls halp!

Any help would be much appreciated!

Thanks,

James.

[Jayapriya]

Hi All,

How can I highlight my O/P file's header with specific color? Can any one help me on this?

Thanks,

Jayapriya M