I guess my inputs / output are not clear enough. Sorry... English is not my primary language...
Dataset A:
USERID CITY PROVINCE DATE_REGISTRATION
lyncgar Ottawa Ont sept12, 2008
chalmyl Ottawa Ont aug23, 2008
charman Ottawa Ont july11, 2008
camejef Ottawa Qc oct01, 2008
falardn Ottawa Qc july14, 2008
renadia Gatineau Qc sept25,2008
lavonat Gatineau Qc jan12,2008
philisa Gatineau Qc jan08,2008
Dataset B;
CITY PROVINCE NUNITS
Ottawa Ont 2
Ottawa Qc 1
Gatineau Qc 2
Output:
USERID CITY PROVINCE DATE_REGISTRATION
lyncgar Ottawa Ont sept12, 2008
chalmyl Ottawa Ont aug23, 2008
camejef Ottawa Qc oct01, 2008
renadia Gatineau Qc sept25,2008
lavonat Gatineau Qc jan12,2008
... View more