Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Comparing Two Lists

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

3 Replies
jhlovenc
Not applicable

Re: Comparing Two Lists

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)

Not applicable

Re: Comparing Two Lists

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

Not applicable

Re: Comparing Two Lists

Should I Create another Tab or Use List B Tab?