Match two columns by values not by rows

[#1]

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

[malini_qlikview]

Hi,

You can use exists and Not exists function to achieve this,

Pls find attached

[#3]

Thanks, please post the script.

[#4]

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.

[#5]

I did individually,

Col2

Where not exists(col1,col2)