06-18-2020 10:21 AM
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
06-26-2020 08:44 AM
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.
12-08-2023 02:14 AM
Hi!
Can you use a mask rule to map all "none mapped Profit Center" to None? It is the simplest way.