Good Evening, I have two columns which have comma seperated values. i need to Comapre and caputre the diff in new column as Diff_column. s.no column_x column_y ---- --------- -------- 1 40,80,70,90,30 40,80,70,30 2 40,80,70,90,30 40,80,70,10,30 If the column_x has 70,80,90 and the column_y doesn't have 10, then don't capture the values 70 or 80 or 90 in diff_column. Expected Result: --------------- s.no column_x column_y diff_column ---- --------- -------- ----------- 1 40,80,70,90,30 40,80,70,30 - 2 40,80,70,90,30 40,80,70,10,30 90 Thanks in advance. Sarav
... View more
