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.

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.