Forum Discussion

e_poveda's avatar
e_poveda
New Contributor III
15 hours ago
Solved

Transformation Rule - Split - Complex Expression

I need to get, from a Custom Dimension, the characters starting after "D." or "T." when it's possible. Normally it comes as D. or T. at the beginning, followed by XYZ. What I want to get, as a direct mapping, is XYZ (these are the members created in the Custom Dimension in OneStream).

What type of mapping can I use for this? I don’t want to trim the source member in the Data Source because I need the full original source member to appear in Stage.

Extenders
Parsing
XFBR
  • e_poveda's avatar
    e_poveda
    10 hours ago

    Thanks for your answer. 

    I had been testing different approaches as you suggested, but in the end, for it to work, it has to be done through a Complex Expression.

3 Replies

  • PKiernan's avatar
    PKiernan
    Icon for OneStream Employee rankOneStream Employee
    10 hours ago

    Have you tried a Mask rule where the Rule Expression is D. and the target value is  *,  Or D.??? to ??? . This is assuming the source star equals to target star, or the length of the question marks and source and target values are the same.

    • e_poveda's avatar
      e_poveda
      New Contributor III
      10 hours ago

      Thanks for your answer. 

      I had been testing different approaches as you suggested, but in the end, for it to work, it has to be done through a Complex Expression.

      • DanielWillis's avatar
        DanielWillis
        Valued Contributor
        4 hours ago

        I know you said you wanted to have the full member in stage. Another option is to map the trimmed member in the data source to a different column that isn't used so you have both.