Finding special character(s) in entire row

[alteryxokan]

Hello, 

I have a 2 datasets that I can connect with an ID. 1 data set had a conversion error and some characters are replaced by (?). I also have a clean dataset and I'm looking to see which records got (?). 

Example of data set 1

Client ID	First name	Last name	Address
1	John	D?e	blue ave
2	J?hn	Doe	red ave
3	John	Doe	Green ave

I want to add additional column and see if this client ID had any question mark in any field or not. My expected result will be

Client ID	First name	Last name	Address	Did first dataset have (?)
1	John	Doe	blue ave	yes
2	John	Doe	red ave	yes
3	John	Doe	Green ave	no

Apologies if I could not word it properly. I tried to find a solution but I'm not sure how to explain either. 

Thank you!

[binuacs]

@alteryxokan one approach with batch macro

[apathetichell]

My hunch is that you may want to look at the intermediate step (flagging the specifc records/rows with the ?s dynamically) -if so take a look at this non-macro version...