Skip to main content
O
OSAdmin
June 18, 2020

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.

  • June 18, 2020
  • 1 reply
  • 0 views
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

1 reply

O
OSAdminAuthor
June 26, 2020
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.

N
NicolasArgente
December 8, 2023

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


NicolasArgente_0-1702019622118.png

 

Terms & ConditionsAccessibility statement