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

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

Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

ihave two tables like below.

Tracker table:

Scorecard Table:

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

Condition :

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

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

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

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

ahaahaaha — Wed, 26 Jul 2017 10:24:30 GMT

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

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

Anonymous — Wed, 26 Jul 2017 11:27:26 GMT

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

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

antoniotiman — Wed, 26 Jul 2017 11:32:42 GMT

Hi,

See Attachment

Regards,

Antonio

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

Fri, 28 Jul 2017 17:16:26 GMT

Thank you Antonio .

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

Thank you,

Muthu

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

antoniotiman — Fri, 28 Jul 2017 17:29:53 GMT

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.