Forum Discussion

OSAdmin's avatar
OSAdmin
Valued Contributor
5 years ago

I have a data source where the Entity and UD5 are in general driven from the same column ""Profit Center"", column 6, in a delimited file. However there are instances when the ""Profit Center"" column is BLANK.

Originally posted by Rich House

4/22/2020

Hi, I have a query I'd like to solve. I have a data source where the Entity and UD5 are in general driven from the same column ""Profit Center"", column 6, in a delimited file. However there are instances when the ""Profit Center"" column is BLANK. Is it possible for those instances to use a different column i.e. use the ""Company Code"" column 1.


If its possible, what is the best approach? Or perhaps, can I populate ""Profit Center"" with the ""company code""? I could then use 100 and 600 in my transformation rule

Data Sources
  • OSAdmin's avatar
    OSAdmin
    Valued Contributor
    5 years ago
    Originally posted by Joakim Kulan

    I have now solved it using concatenation on the entity. Applying Company Code, adding a -, then adding Profit Center


    Rich House Yes you could. You could look at the snippet examples of Debit/Credit columns and use the same methodology. Bring in the current value, check if its blank. If its blank then return the value of the second column.

    • NicolasArgente's avatar
      NicolasArgente
      Valued Contributor
      2 years ago

      Hi!
      Can you use a mask rule to map all "none mapped Profit Center" to None? It is the simplest way.

       

Related Content