Finding State, District and Village from address

[Anonymous]

Dear All,

I am trying to find and map State, District and Village master with the data. Can anyone help me out in this?

Thanks in advance.

Regards,

Imran Khan

[robert_mika]

Master:

LOAD

Village,

District,

State

FROM

(ooxml, embedded labels, table is Master);

KeywordVillage:

mapping LOAD Upper(Village),

' '& Village & ' '

Resident Master;

KeywordDistrict:

mapping LOAD Upper(District),

' '& District & ' '

Resident Master;

KeywordState:

mapping LOAD Upper(State),

' '& State & ' '

Resident Master;

Data:

LOAD Addresss,

RecNo() as ReviewId

FROM

(ooxml, embedded labels, table is Data);

Terms:

LOAD

          ReviewId,

      subfield(MapSubString('KeywordVillage', upper(Addresss)), ' ') as Village,

      subfield(MapSubString('KeywordDistrict', upper(Addresss)), ' ') as District,

      subfield(MapSubString('KeywordState', upper(Addresss)), ' ') as State

RESIDENT Data;

Inner Join(Master)

LOAD *

RESIDENT Terms

;

DROP Table Terms;

Thanks to rwunderlich for inspiration from this topic

Re: Create list box of search terms

Just to mention:

S O VENKATAPPA NAIDU D 1 2 3 1  KOBAKA  YERPEDU CHITTOOR ANDHRAPRADESH

is listed twice as there are two villages within the string

[gautik92]

good one Robert_Mika

[Anonymous]

Thanks Robert. You solution is correct. But I have shared the sample data with you whereas my total application size is 7 GB. I tried doing what you suggested but i get error as out of object memory in middle of reload.

Regards,

Imran Khan

[robert_mika]

There few ways to tackle this problem:

-Look at your data model

Do you need all tables/fields?

7 GB look quite heavy even for Qlik

-How big is your source of data?

Can you split it into portions?

Can you save your data into QVD and then make calculations.

This is probably question for another topic so if you feel your question has been answered please mark the topic as such.

[Anonymous]

Dear Robert,

I am having 5 lakhs of row. I tried with one lakhs of rows but it is not working. Can you please suggest me something else.

Regards,

Imran K

[Anonymous]

gwassenaar‌ jaganmohanrao‌ sunindia‌ ashfaq_haseeb‌

I need your help in solving this.

Thanks in advance

Regards,

Imran