Highlight Partial Characters in a table

[Mukulchandravanshi_94]

Hi All,

I am stuck in how to partially highlight the row values in a table in Alteryx. Please refer below example.

So I need to highlight only the text in Col A which is matching in Col B. Like, in Col A, only abc text is matching, so i have highlighted only abc and while in 2nd row, entire text is matching, so entire text is highlighted in purple.

Please suggest how this can be achieved in Alteryx.

A	B
abc, def	abc
abc, def	abc, def

[binuacs]

Spoiler

@Mukulchandravanshi_94 not able to do a partial highlight, 

Spoiler

[Mukulchandravanshi_94]

I am also not able to do it. Tried many things, but not able to resolve it.

[Christina_H]

It's possible to do this by manipulating the HTML code of the table tool, although it causes issues with the render tool.  I needed to connect the table tool directly to the render tool first, then add the formula.  After the formula is applied, the render tool doesn't recognise the output as a valid field but will still work if the field was previously selected.

Output: