Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Partner - Master
Partner - Master

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

Anonymous
Not applicable
Author

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

Hi,

See Attachment

A:

B:

C:

Regards,

Antonio

Not applicable
Author

Thank you Antonio .

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

Thank you,

Muthu

antoniotiman
Master III
Master III

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.