Comparing Two Lists

[#1]

Hello Guys,

I am new to qlikview and I need some help. I am trying to compare two lists and both the list have same exact field name. I am trying to compare the one particular field (Meter ID) and see how many records are different from list A. Please see below list for more detail. Please Help!!!!!

List A:

METER_ID

,
MODULE_ID,
PRIME_MCC,
M_STREET_ADDRESS,
M_COUNTY,
SR_NAME,
P_STREET_ADDRESS,
P_COUNTY,
ENTRY_DAT,
LPT1,
CAL_DAYS,
ORIG_DISC,
LATEST_DI,
DAU,
DAU_DAYS,
M_CITY,
P_CITY,
POSS_MTR_COUNT,
POSS_MTR_ID,
POSS_MTR_ADD,
POSS_MTR_ADD_OVER,
POSS_MTR_CITY,
ORPHAN_READ,
Energy,
CIMS_MFG_CODE,
EQUIPMENT_NUMBER,
Issue_Date,
USER_NAME,
CIMS_SIZE_CODE,
Age,
AvgUsage,
GPS_LONG,

GPS_LAT

List B:

METER_ID

,
MODULE_ID,
PRIME_MCC,
M_STREET_ADDRESS,
M_COUNTY,
SR_NAME,
P_STREET_ADDRESS,
P_COUNTY,
ENTRY_DAT,
LPT1,
CAL_DAYS,
ORIG_DISC,
LATEST_DI,
DAU,
DAU_DAYS,
M_CITY,
P_CITY,
POSS_MTR_COUNT,
POSS_MTR_ID,
POSS_MTR_ADD,
POSS_MTR_ADD_OVER,
POSS_MTR_CITY,
ORPHAN_READ,
Energy,
CIMS_MFG_CODE,
EQUIPMENT_NUMBER,
Issue_Date,
USER_NAME,
CIMS_SIZE_CODE,
Age,
AvgUsage,
GPS_LONG,

GPS_LAT

[Anonymous]

You will need to rename all the fields in List B with the exception of Meter_ID so you have only one hook up.  East to take List B into Excel and concatenate the field name with something like _B.  (Module_ID_B)

[#3]

Ok, I did now I have Module_ID from list A and Module_ID_B fronm list B as shown below. Then how should I deffernciate two lists?

List A                                   List B

Module_ID                         Module_ID_B

[#4]

Should I Create another Tab or Use List B Tab?