Skip to Content
0
Former Member
Feb 26, 2011 at 11:38 PM

Compare Rows and replace the Value

33 Views

Hi all,

I need to compare two records and when it matches I have to replace with the row data for the other column.

For Example:

Id..............Name............Location...........Path

1...............AAA................ABC.................CBA

2...............BBB................DEF.................FED

3................. - ................. GHI..................CBA

Here the rows from the Path Column is compared and if it matches then I have to replace Name column with the same date as of that row.

So from the above example when Id 1 & 3 are compared Path column (CBA = CBA) is matched and I have to replace AAA in the Name Column for Id 3.

Note: The comparison should be in any row in the entire report for that particular column.

Thanks,