Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
sdepotter
Contributor
Contributor

finding dupplicate values in two different files

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

1 Solution

Accepted Solutions
rubenmarin

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.

View solution in original post

4 Replies
tomasz_tru
Specialist
Specialist

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

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.

View solution in original post

sdepotter
Contributor
Contributor
Author

Thank you for the help! this works perfectly

Sam

sdepotter
Contributor
Contributor
Author

Thanks! this solved my issue