Hi Vince, Thanks for the reply. The scenario is as below: we have to get flagging for every comparison of columns whenever it get two column with same value, we should create a flag for that and this is matching of columns not in continuous manner. There may be situation like the value of col1 matches with col15.... e.g., suppose you have col1 = apple and col2 = apple then flag1 = 1; if col1 = apple and col2= mango then flag1 = 0. Similarly, if col1 = apple and col3 = apple then flag1 = 0, flag2 = 0, flag3 = 1 and so on.... Once we get col1 = apple and col2 = apple, we should compare col2 with other columns. e.g., col2 with col3, col 2 with col4, col2 with col5 and so on.....and whenever we get match....create a flag for that. ... View more

Hi DR.Majeti, Yes, we have to get flagging for every comparison of columns whenever it get two column with same value, we should create a flag for that. e.g., suppose you have col1 = apple and col2 = apple then flag1 = 1; if col1 = apple and col2= mango then flag1 = 0. Similarly, if col1 = apple and col3 = apple then flag1 = 0, flag2 = 0, flag3 = 1 and so on.... Once we get col1 = apple and col2 = apple, we should compare col2 with other columns. e.g., col2 with col3, col 2 with col4, col2 with col5 and so on.....and whenever we get match....create a flag for that. Please see attached .text file in my query. There are columns d1, d2, d3......so on..... Let me know if you need more information. Thanks, Abhee ... View more