You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Conditional Source Expression with Concatenation as output

Summary:

We are migrating HFM Import scripts to cloud. I am planning to leverage Conditional expression to achieve similar functionality but it is not working.

Basically we plan to concatenate couple of columns depending on the condition. I am unable to concatenate two values . I am getting error.

if (split(RECORD,"|",6) !="" and UD4 !=null) return "UD4 + split(RECORD,"|",6)"
else return split(RECORD,"|",6)

I tried Concat("UD4|split(RECORD,"|",6)","_") but both options did not work.

I would appreciate if could anyone provide sample for concatenated two columns in source expression.


Content (please ensure you mask any confidential information):


Version (include the version you are using, if applicable):

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!