Views to display different text than field
"To display Yes or No for field_url" - I done something similar to this but with Drupal 6 and Views Custom Field. 

So for Drupal 7, I think you need to use Views PHP and add Custom Field:PHP field in your view and make conditions.

&lt;?php 

$static = $this-&gt;view-&gt;display_handler-&gt;get_handlers('field');

$x=$static['tid_1']-&gt;last_render;
$y=$static['tid_2']-&gt;last_render;

if($x !== null)
{
echo "&lt;a href='#Your link'&gt;"."Yes"."&lt;/a&gt;";
}
else
{
echo "NO";
}

?&gt;


note: tid_1, tid_2 are field tokens, instead change it with your fields token.