Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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.
Hi Dennis,
That works perfectly, thanks.
Alan
Hi Dennis,
How would I do this if the two fields that I want to compare are in two different tables?
Thanks
Alan
Hi,
Use Exists(FieldName) in the Where clause.
Field name should be common in both the table.
Hope it helps
Celambarasan
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