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,