topic Re: Comparing Two Lists in QlikView

Comparing Two Lists

Thu, 07 Mar 2013 19:18:22 GMT

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

GPS_LAT

Re: Comparing Two Lists

Anonymous — Thu, 07 Mar 2013 20:01:00 GMT

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)

Re: Comparing Two Lists

Thu, 07 Mar 2013 20:08:38 GMT

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

Re: Comparing Two Lists

Thu, 07 Mar 2013 20:17:31 GMT

Should I Create another Tab or Use List B Tab?