Hello,

I am working on a data flow that needs to perform various substring functions to isolate data from a large xml string.

I have gotten it close, where the data is linked to the log / time / user in in the sql database, and i am able to separate values into appropriately named columns.

I would like to know if/how to condense these rows so that the nulls disappear, and only the log, starttime, logged in user (these should be the same across all rows that have the same log)(log is unique so there will not be more than one row that has a value)

Please see picture below:

Thank you!