topic Finding value from large string in QlikView

Finding value from large string

Wed, 29 Jul 2015 06:07:52 GMT

Hello All,

I need urgent help on finding District and Village information from the address based on Mater table.

My requirement is mentioned below based on attached sheet;

1) Master tab include master information of State, District and Village information which is the master information

2) Second tab include address information from which Master table need to be mapped. For example; Master table is having Stage as Maharashtra, District as Mumbai and Village as Andheri and want to search similar information in Address tab. If Address values matches with Master table then i would like to do tag it with Confirm, if not then probable

Thanks in advance.

Regards,

Imran Khan

Re: Finding value from large string

robert_mika — Wed, 29 Jul 2015 06:46:24 GMT

Are all your data in the same format?

last three words describe the output?

Re: Finding value from large string

Thu, 30 Jul 2015 07:49:15 GMT

Thanks Robert for your quick response.

No Robert. The output which i am looking for, can be at any part of the address.

Re: Finding value from large string

robert_mika — Thu, 30 Jul 2015 07:55:00 GMT

Could you post more examples?

Re: Finding value from large string

avinashelite — Thu, 30 Jul 2015 08:08:18 GMT

please find the attachment for the solution

Hope this helps you

Re: Finding value from large string

Thu, 30 Jul 2015 08:55:16 GMT

I am unable to find any attachment.

Re: Finding value from large string

avinashelite — Thu, 30 Jul 2015 09:43:09 GMT

please see now