DSXchange

Hi All,

While comparing two datasets along with identifying which row is changed how to Capture column names when a value changes in that particular column or columns.

This first time I have come-acrossed this kind of requirement, does any one have any idea on how to do this.

Thanks
srimitta

I have implemented this in the past in which the requirement was to detect any change in any x number of columns. My method was to pivot the row into columns along with the column name. So my n column row would change into n rows with two columns. The first column is the column name and the second is the value. This way if any change is detected, the filtered row has the changed value and the column name.