Inferring Gender from Title or Honorific and Gender Reversal
Sometimes it might be useful to determine the gender of a person from their honorific, so for example deciding that the greeting should be Sir or Madam depending on the Mr or Mrs or Miss honorific.
The interesting aspect of this inferral task is that in Data Studio there are a good many ways that you can achieve this result.
Here's one that uses the EQUALS condition evaluation and IF THEN ELSE operators
The result is then as follows
You can also look at using lookups but this would require you to have a lookup list that has both Honorific and Saluation in the same dataset.
Is there another way you could do this, perhaps using a regular expression?