Highlight Partial Characters in a table

Question

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.

ABabc, defabcabc, defabc, def

Christina_H · Answer

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:

Partial bold.yxmd

Mukulchandravanshi_94 · Answer

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

binu_acs · Answer

Spoiler

@Mukulchandravanshi_94 not able to do a partial highlight,

Spoiler

Full_highlight.yxmd