Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
Not applicable

Finding value from large string

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

Tags (1)
6 Replies

Re: Finding value from large string

Are all your data in the same format?

last three words describe the output?

Not applicable

Re: Finding value from large string

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

Could you post more examples?

Re: Finding value from large string

please find the attachment for the solution

Hope this helps you

Not applicable

Re: Finding value from large string

I am unable to find any attachment.

Re: Finding value from large string

please see now