Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!!!!!
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
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
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)
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
Should I Create another Tab or Use List B Tab?