1 to Many Map Table

DanRonsman — Tue, 10 Nov 2020 16:13:29 GMT

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?

Re: 1 to Many Map Table

Kushal_Chawda — Tue, 10 Nov 2020 17:07:28 GMT

@DanRonsman you can either join or simply link it with other table on zip

topic Re: 1 to Many Map Table in QlikView

1 to Many Map Table

Re: 1 to Many Map Table