Need Help with Multiple Derived Fields in CJA and Getting Values

[MichaelJo13]

I have two derived fields. The first one, "Mobile App Version" filters out specific values using the Regex Replace" function. The second one, "Mobile DL Version" filters out specific values using the Regex Replace" function. Both are created as dimensions. What I want to do is check if "Mobile App Version" returns a value then use that value. If no value from "Mobile App Version", then check if "Mobile DL Version" returns a value, then use it. If neither returned a value, then return the string "Invalid Version". How can I do this?

Thanks!

[MichaelJo13 · Accepted solution]

I figured a way to do it. I had to use the "Merge Fields" function and then a regex to get the values I wanted and then a Case function to check if the value was set return it, otherwise return "Invalid Version".  

[Sukrity_Wadhwa]

Thanks @MichaelJo13 for sharing the solution with the Community! 🙂