Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
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

6 Replies
robert_mika
Master III
Master III

Are all your data in the same format?

last three words describe the output?

Not applicable
Author

Thanks Robert for your quick response.

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

robert_mika
Master III
Master III

Could you post more examples?

avinashelite

please find the attachment for the solution

Hope this helps you

Not applicable
Author

I am unable to find any attachment.

avinashelite

please see now