finding dupplicate values in two different files

[sdepotter]

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

[tomasz_tru]

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/In...

[rubenmarin · Accepted solution]

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.

[sdepotter]

Thank you for the help! this works perfectly

Sam

[sdepotter]

Thanks! this solved my issue