Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 :
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
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
//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
Hi,
See Attachment
A:
B:
C:
Regards,
Antonio
Thank you Antonio .
Can we get A, B and C together without commenting it.\
Thank you,
Muthu
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.