Compare 2 columns & display unique values

[#1]

Hi,

I have a file with 2 non-identical columns: A & B. Each entry in Column A has an entry somewhere in Column B. I want to display a list of entries that will compare all the entries in A with those in B and only display those that are missing from B.

In Excel this works:

=IF(COUNTIF(B:B,A2)=0,A2,"")

I have attached a sheet containing some dummy data and  the excel formula working correctly.

Any help would be greatly appreciated...

Thanks

A

[Anonymous · Accepted solution]

Hi A,

Try this in your script:

Data:

LOAD [Column A],

     [Column B],

     If (ISNULL([Column B]) , [Column A]) as [Column C]

FROM

[..\QV Missing IDs.xls]

(biff, embedded labels);

Good luck,

Dennis.

[#3]

Hi Dennis,

That works perfectly, thanks.

Alan

[#4]

Hi Dennis,

How would I do this if the two fields that I want to compare are in two different tables?

Thanks

Alan

[CELAMBARASAN]

Hi,

     Use Exists(FieldName) in the Where clause.

     Field name should be common in both the table.

Hope it helps

Celambarasan

[#6]

Hi Celambarasan,

Thanks very much for your prompt response.

Would you mind specifying how this would be incorporated into the script?

I am very new to Qlikview...

Cheers

Alan