Compare two tables excel

[#1]

Hello,

I need to compare two tables from different excel. When I get two equal reference I need to write "True" and otherwise "false"

excel 1:

Reference1	Country	Information
123456	USA	AAAAA
234567	UK	BBBBB
345678	CA	CCCCC

excel 2:

Reference2	Country	Code
456789	FRA	EEEEE
123456	USA	DDDDD

I think I need to creat a new table:

TABLE:

COUNTRY	Reference	Information	Code	Flag
USA	123456	AAAAA	DDDDD	TRUE
UK	234567	BBBBB		FALSE
CA	345678	CCCCC		FALSE
FRA	456789		EEEEE	FALSE

Until now, I tried to make an "If" : if(Refence1 <> Reference2, 'true', 'false') as Flag

But I have an issue with this condition, when the charging never stop.

Regards

[sunny_talwar]

Are you looking to do this in the front end of the application? Will a backend solution also work for you?

[marcus_malinow]

Try this...

Table:
LOAD Reference1 as Reference,
Country,
Information,
-1 as Source1
FROM
[https://community.qlik.com/thread/189107]
(html, codepage is 1252, embedded labels, table is @1);

Outer Join (Table)
LOAD Reference2 as Reference,
Country,
Code,
-1 as Source2
FROM
[https://community.qlik.com/thread/189107]
(html, codepage is 1252, embedded labels, table is @2);

LEFT JOIN (Table)
LOAD
Reference,
Country,
if(Source1 And Source2, -1, 0) as Flag
RESIDENT Table;

[#4]

I need a backend solution

[sunny_talwar]

May be this:

Table1:

LOAD Reference1 as Reference,

    Country,

    Information

FROM

[https://community.qlik.com/thread/189107]

(html, codepage is 1252, embedded labels, table is @1);

Join (Table1)

LOAD Reference2 as Reference,

    Country,

    Code

FROM

[https://community.qlik.com/thread/189107]

(html, codepage is 1252, embedded labels, table is @2);

FinalTable:

LOAD *,

  If(not IsNull(Information) and  not IsNull(Code), 'True', 'False') as Flag

Resident Table1;

DROP Table Table1;

Output:

[#6]

There is a way to make your condition only with "reference1" and "reference2"? Because I didn't only have 1 column of "information" and "code".

Thanks for your help

Regards

[sunny_talwar · Accepted solution]

May be like this then:

Table1:

LOAD Reference1 as Reference,

  Reference1,

    Country,

    Information

FROM

[https://community.qlik.com/thread/189107]

(html, codepage is 1252, embedded labels, table is @1);

Join (Table1)

LOAD Reference2 as Reference,

  Reference2,

    Country,

    Code

FROM

[https://community.qlik.com/thread/189107]

(html, codepage is 1252, embedded labels, table is @2);

FinalTable:

LOAD *,

  If(Reference1 = Reference2, 'True', 'False') as Flag

Resident Table1;

DROP Table Table1;

[#8]

Thanks it work!

[sunny_talwar]

Awesome