Hi,
Is there a way to assign a value to an element base on a condition? For example, like the following screen, can I assign “Man” or “Woman” inside a concat function if there is a field in the source called Gender with M or F value? Can I have if-then-else inside Concat() function? In fact, I would like to construct a sentence with certain condition like “This is a <Man/Woman> who is <young/old>” base on 2 different source field “Gender” and “Age”. Any idea? thanks
regards,
Kinson