Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

APPLYMAP comma separated with more values possible?

Hello,

I Currently have following code (example):

mapcity:

MAPPING LOAD

[PROVINCE.Province],

[PROVINCE.City]

Resident PROVINCE;

CITY:

Load   APPLYMAP ('mapcity', CITY.Province)          as CITY.City,

          .....,

          .....,

From [$(Path)\CITY.qvd]

Because There are more City's in every province it will still only add 1 City to CITY.City.

Is there a possibility that it will add more City's to CITY.City seperated with a comma (,)?

Or do i need to use something else then mapping?

Thanks a lot.

1 Reply
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

No, you need to use a join instead if you want all the cities added to the provinces.


talk is cheap, supply exceeds demand