Highlight cells according to a input list file

[Riiiiita]

hi all, please help and advise if you have any solution on below? Thanks!

Dataset:

Name

Amy

Ben

Celia

Daisy

Elle

Forest

Geollen

Haily

Immy

Jack

Ken

A separate name list file (will be updated from time to time):

Highlight Name

Ben

Celia

Elle

Geollen

Immy

Ken

Expected Result:

Can I setup any format rule to reach the below goal? Thanks!

Name

Amy

Ben

Celia

Daisy

Elle

Forest

Geollen

Haily

Immy

Jack

Ken

[shancmiralles]

hi! your inquiry is relevant to this previous topic:
https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Highlight-specific-text-in-tab...

[Riiiiita]

thanks for the reply, however, I can't simply apply the rule on the text/ string directly, the highlighted part is dependent on the file (highlight name list) I input, no idea if it's feasible in Alteryx.

[TUSHAR050392]

Hey, I think you can use the above solution by tweaking it a bit. First you can use find and replace tool, F will

be Name file and R will be Highlighted Name file and make two column - Name and Highlighted Name. Wherever there will be a match, highlighted Name will have value else Null. Then use the Table tool and create the row formula rule - If highlighted column is not null then color and at the same time you can uncheck highlighted column from table so that way you will only get Name column and also highlighted.

This way your highlighted name file can have dynamic values. Hope this helps.

[gawa]

@Riiiiita You can utilize "Column Rules" option in the Table tool.

In your case, you need to highlight the users that exists in the "Highlight Name", then you can Left Outer Join "Name" and "Highlight Name" and put flag for matched users. And, by using that flag as conditional formatting in the above said option, you can change font as you wish.

FYI, I'm attaching WF. You can use it for your reference.

[apathetichell]

two file browse tools (if needed) - one for full dataset - one for match file. 

join tool.

formula tool to join - create new field Green - give it an int value of 1

anchor of your full data set unjoined - create new field Green give it an int value of 1.

union

table tool

highlight your name column (or whatever) - create a column rool.

column rool applies when Green ==1

set text color = green

use render to output.

[binuacs]

@Riiiiita another approach