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

source expression transformation after CONCAT

edited May 13, 2025 11:11PM in EPM Platform and Freeform 2 comments

Hello,

Currently, we have a client who is migrating from HFM to FCC, and they used to rely on FDMEE scripts to transform data during the import process

Now, in Data Exchange, we are using the Source/Target Expression functionality.

In the source expression we use CONCAT:

which works; however, we are unable to clean the data properly. This is because this source doesn’t allow adding conditionals, so even when a column is blank ("") or null, it still adds the delimiter. For example:

A99999-- (Double dash)

Is it possible to stack Source expressions in one single dimension or even use conditional ?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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