I got 3 columns, name, col1, col2, I want to output 2 columns only
col1== col2 OR col1!=col2 in each row
but my final output only 2 column
INPUT:
|
name |
col1 |
col2 |
| row1 |
A |
1 |
1 |
| row2 |
B |
2 |
22 |
| row3 |
C |
3 |
333 |
| row4 |
D |
4 |
4 |
OUTPUT:
|
name |
column |
|
| row1 |
A |
1 |
|
| row2 |
B |
2 |
|
| row3 |
B |
22 |
|
| row4 |
C |
3 |
|
| row5 |
C |
333 |
|
| row6 |
D |
4 |
|