topic Re: Finding a Particular mapping String in a Field in QlikView

Finding a Particular mapping String in a Field

Anonymous — Fri, 24 Aug 2018 09:51:55 GMT

Dear Friends

I have a field which has long data in it. From this long data I need to find particular city/country from a mapping sheet.

Example:

In attached Excel Sample data I have a City sheet which has names of the cities (Mumbai, Bangkok, Dubai) . I want to search for these cities in different separate table - long field sheet.

In Long field sheet, column name - Field we have Mumbai in first record, Bangkok in second record and Dubai in third record.

So we should pick these 3 cities and display.

Kindly help me to achieve the output.

Thanks & Regards

Chintan Gala

Re: Finding a Particular mapping String in a Field

stigchel — Fri, 24 Aug 2018 10:02:59 GMT

Please don't repeat your posts. I've replied to your previous post which should solve this example as well

Find particular string in a field from mapping sheet

Re: Finding a Particular mapping String in a Field

Anonymous — Fri, 24 Aug 2018 11:22:58 GMT

Apologies for the trouble Piet.