Substitution unexpected behaviour
For a table of Clients, using a Substitution rule I first updated all FirstName with dataset Names, First Name, Male. I followed that with a dependent Row Internal Rule to update by Salutation with:
CASE WHEN Salutation='Mr.' THEN DMSPARAM1 WHEN Salutation='M.' THEN DMSPARAM1 WHEN Salutation='Miss' THEN DMSPARAM2 WHEN Salutation='Mlle.' THEN DMSPARAM2 WHEN Salutation='Mme.' THEN DMSPARAM2 WHEN Salutation='Mrs.' THEN DMSPARAM2 WHEN Salutation='Ms' THEN DMSPARAM2 END
In this case DMSPARAM1 is the dataset Name, First Name, Male; DMSPARAM2 is Name, First Name, Female.
The result was NULL values in FirstName for the Salutations that I had overlooked: Mr and Ms.
Why is that?
0 · Share on Twitter