Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
Highlighted
Not applicable

How to match data and how to get matched data for multiple scenarios?

Hi All,

ihave two tables like below.

Tracker table:

Screenshot_2.png

Scorecard Table:

Screenshot_1.png

Based on above table ineed to get output like A,B,C D

Condition :

A:

Need to get all the data only for the Meter Id matches in both Tracker Table and Scorecard table.

B:

Need to get all the data only for the Meter Id Present in Tracker table not present in Scorecard

C:

Need to get all the data only for the Meter Id Present in Scorecard not present in Tracker

Kindly provide me the efficient Method to get above out put.and kindly help me out of it  so that it will be use full for my learning process

Please find the attached Excel Data

Thanks,

Muthu

5 Replies
ahaahaaha
Honored Contributor

Re: How to match data and how to get matched data for multiple scenarios?

Hi Muthu,

May be like at attached file?

1. Each script uses its own script editor tab. The other two tabs should be commented out.

2. If the size of the source files is small, you can use the proposed code. If the source files are large, I recommend that the source tables be fully loaded in Qlik, and then with them, they should work as resident ones.

Regards,

Andrey

tnbcherry
New Contributor II

Re: How to match data and how to get matched data for multiple scenarios?

//You should link your two tables first.

//Have a fieldname the same in both tables.

Tracker_table:

LOAD

Utility_ID,

Meter_No as Meter_ID,

Issue_ID,

Issue

FROM

Scorecard Table:

LOAD

Pending_ID,

Meter_No as Meter_ID,

Issue_ID as s_Issue_ID,

Service_Order,

Job_ID

FROM

//Then create a Table Box to show the results for your A, B, and C

antoniotiman
Honored Contributor III

Re: How to match data and how to get matched data for multiple scenarios?

Hi,

See Attachment

A:

B:

C:

Regards,

Antonio

Not applicable

Re: How to match data and how to get matched data for multiple scenarios?

Thank you Antonio .

Can we get A, B  and C together without commenting it.\

Thank you,

Muthu

antoniotiman
Honored Contributor III

Re: How to match data and how to get matched data for multiple scenarios?

Yes, however You have linked among them e many Synthetic Keys.

If You Want avoid this You need rename Fields Names or using Qualify Fields/Unqualified Fields.

You can  remove // and try.