Making views display one field if other is empty

Setting up a view system for I encountered a problem.

I needed to show a formatted field if another (formatted) one wasn't present, in a switch case manner)

I found the solution in the Drupal forum: reply #10 did the trick.

  1.  Add both fields
  2. Make the first one invisible (exclude from display)
  3. In the second field go to no result behavior tab.
  4. Write the token of the first field (example: [field_name]).

This worked like a charm and even allows the no result behavior to be output as HTML.

Nice workaround!