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.

OSAdmin
Valued Contributor
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.

116171e0db291010a26240981396197b.png

2a51bda0db291010a262409813961940.png
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

2 REPLIES 2

OSAdmin
Valued Contributor
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.

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

 

Connect with me on:
LinkedIn: https://www.linkedin.com/in/nicolas-argente/
Website: https://aiqos.io
If you want to lift yourself up, lift up someone else.
Please sign in! OSAdmin