Conditional Formatting for identical numbers

[gavinloi]

Hi all,

Would there be a way where alteryx workflow would be able to help with conditional formatting or prompting of identical numbers ?

I would require the joining of 2 excels "1" and "2" and if there are similar 'numbers' the conditional formatting would prompt like below.

Example would be John and Amanda with numbers 1 would be flagged as well as Jane and Justina with numbers 3 be flagged.

Thank you!

'1' excel

'2' excel

Final output

Thank you!

[apathetichell]

see attached. basically you can control this with row rules in a table prior to render. You count values and then check the count field which you omit from the table.

[Qiu]

@gavinloi 
Hope this would work for you.

[gavinloi]

Thank you! hmm.. seems like i do not have the latest version to show the functionality. Let me try getting it and testing it again.

[gavinloi]

Thank you! For the output be able to be in an excel file instead ? I tried to change it instead of browse and it doesn't seem to work.

[apathetichell]

yes - but you have to go to excel via render tool.