Need to do a Conditional Replacement on HCM Extract with EText Template
Summary:
Hello!
I have 5 Value Set/Fast Formula for attributes in HCM Extract. 4 of them have some conditions to change a information showed on the 5th(The 5fth one is an flexfield value, and depending on 4 conditions it would displace otherthing).
Can I use a IF on the attribute, like this:
IF SHORT1 IS NULL THEN SHORT2
IF SHORT1 IS NULL AND SHORT2 IS NULL AND LONG1 IS NOT NULL THEN LONG1
IF SHORT1 IS NULL AND SHORT2 IS NULL AND LONG1 IS NULL THEN LONG2
IF SHORT1 IS NULL AND SHORT2 IS NULL AND LONG1 IS NULL AND LONG2 IS NULL THEN NORMAL_ATTRIBUTE