Forum Discussion

KH1's avatar
KH1
New Contributor III
10 months ago

Data Sources v Transformation Rules - mapping blanks

G'day ONE members, There are blanks for some rows in certain Dimensions in our source data files. 1. In DS w/o using a Logical Operator, pls share how to map those blanks to new values, and/or 2....
Data Sources
Transformation
  • MarcusH's avatar
    MarcusH
    10 months ago

    I had another thought about this. You can create a List type map with the source value of ; (semicolon). That seems to pick up blank source records. I haven't tested it fully but it seems to work.

  • tuhler's avatar
    tuhler
    10 months ago

    I use the Leading Fill Value setting in the data source to add a value to blanks. This will only add to the value if there are less characters in the dimension than there are in the leading fill value.

    For example, if your leading fill value is set to ### and the file has a value of "x" the data source value would show "##x" or if the file has a blank value, it would show "###"

tuhler's avatar
tuhler
New Contributor III
10 months ago

I use the Leading Fill Value setting in the data source to add a value to blanks. This will only add to the value if there are less characters in the dimension than there are in the leading fill value.

For example, if your leading fill value is set to ### and the file has a value of "x" the data source value would show "##x" or if the file has a blank value, it would show "###"

  • KH1's avatar
    KH1
    New Contributor III
    10 months ago

    G'day tuhler,
    Your brilliant advice works - we owe you.:steaming_bowl:
    How did you figure it out?
    TY. 👍

    • tuhler's avatar
      tuhler
      New Contributor III
      10 months ago

      In the design and reference guide it makes note of this property. I had always assumed that the leading fill value would always prefix the value but could never get it to work. That is when I found this page in the guide: Source Dimension Properties (onestreamcloud.com)

      • KH1's avatar
        KH1
        New Contributor III
        10 months ago

        G'day tuhler - TY for sharing the page.

        How did you figure to use Leading Fill Value to map the blanks?
        Do you know a TR to map the blanks?

        TY.