Combine 2 datasets and include the duplicates
7 views (last 30 days)
I have two datasets, the first is a list of postcodes gathered from a survey, the second is a matrix that cross-references all postcodes with the areas they are in. I want to generate a column listing the areas that the survey postcodes represents.
The part I am having trouble with is that in some cases, one postcode can correspod to mutiple areas, in these situations I want to include both areas in the new column.
I've tried joining the tables, but the standard Join command seems to have issues with there being duplicate values
ANKUR KUMAR on 17 Mar 2021
If it helps you, then it's good. Otherwise, if you can provide the datset (or sufficient variables in a mat file), it owuld help us to help you.