Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
good one Robert_Mika
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
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.
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
gwassenaar jaganmohanrao sunindia ashfaq_haseeb
I need your help in solving this.
Thanks in advance
Regards,
Imran