topic Re: finding dupplicate values in two different files in QlikView

finding dupplicate values in two different files

sdepotter — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I'm trying to find dupplicate values in two different files. I want to compare column A (from File A) to column B (from File B). I only find solutions on the forum that require a these two columns to have an identical header (i.e. key).

creating a key between the two files resulted in loops and my report does not work anymore.

is there a way to copare these two columns in absence of a shared key?

any help is much appreciated.

Thanks

Sam

Re: finding dupplicate values in two different files

tomasz_tru — Tue, 15 Jan 2019 14:41:28 GMT

I'm not really sure whats's your intention, but maybe this one can help to create table with duplicated values:

https://help.qlik.com/en-US/qlikview/November2018/Subsystems/Client/Content/QV_QlikView/Scripting/InterRecordFunctions/Exists.htm

Re: finding dupplicate values in two different files

rubenmarin — Tue, 15 Jan 2019 15:40:43 GMT

Hi, once you have laoded one of the tables you can use the laoded values to check in the other table,ie:

TableA:
LOAD ColumnA
from ...;

TableB:
LOAD ColumnB,
if(Exists(ColumnA, ColumnB), 1, 0) as isInTableA
from...;

This creates a flag field wich sets 1 to the record values that has been loaded in ColumnA. Exists can also be used in the 'where' clause to filter loaded records.

Re: finding dupplicate values in two different files

sdepotter — Tue, 15 Jan 2019 15:47:02 GMT

Thank you for the help! this works perfectly

Sam

Re: finding dupplicate values in two different files

sdepotter — Tue, 15 Jan 2019 15:48:14 GMT

Thanks! this solved my issue