I am trying to map Zip Codes to their corresponding CBSA. 1 Zip Code can belong to many CBSA's. See raw table below.
| Zip | CBSA |
| 00612 | 41980 |
| 00612 | 10380 |
| 00612 | 11640 |
Currently, I am using a Map Table to load the lookup table from an Excel crosswalk file. See code below.
MAP_ZipToCBSA:
MAPPING LOAD
ZIP
, CBSA
FROM
$(vExternalDataPath)\zip_to_cbsa.xlsx
(ooxml, embedded labels, table is ZIP_CBSA_032020)
GROUP BY ZIP;
With this solution only the first CBSA is returned. I want to return all CBSA's for the Zip Code. Does anyone have an alternative solution?
