Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Read about Qlik’s Response to COVID-19 Read the Letter, Join the Group.
Highlighted
Contributor

Finding State, District and Village from address

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

Tags (1)
6 Replies
Highlighted

Re: Finding State, District and Village from address

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;

2015-08-31_091944.png

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

Highlighted
Valued Contributor III

Re: Finding State, District and Village from address

good one Robert_Mika

Highlighted
Contributor

Re: Finding State, District and Village from address

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

Highlighted

Re: Finding State, District and Village from address

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.

Highlighted
Contributor

Re: Finding State, District and Village from address

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

Highlighted
Contributor

Re: Finding State, District and Village from address

gwassenaarjaganmohanraosunindiaashfaq_haseeb

I need your help in solving this.

Thanks in advance

Regards,

Imran