Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How to match two columns by values and display matching values in another seperatega column and nonmatching of inside these columns separately. E.g
Column1. Column2
1. 3
2. 1
4. 6
5. 5
8. 3
3.
Expected Result:
Column1.Column2.Column3(match).Column4(nonmatchedvaluesofcolumn1).Column5(..col2)
.... ..... 1. 2 6
3. 4
5. 8
Hi,
You can use exists and Not exists function to achieve this,
Pls find attached
Thanks, please post the script.
If(exists(col1,col2), col2) as unmatchcol1.
If(exists(col2,col1),col1) as unmatchcol2.
These are correct? If not can you post script for the three columns including match col.
I did individually,
Col2
Where not exists(col1,col2)