I am new to qlikview, but am experienced in other programming languages VBA, SQL, C and I am just needing some help with a problem that I have.
I have 2 excel sheets sheet 1 contains a list of customers and has 5 fields that I need to look at ("address line 1", "address line 2", "address line 3", "address line 4", "address line 5")
Sheet 2 then contains a list of "Countries", there "Demonym" and there "status"e.g
Address 1
Address 2
Address 3
Address 4
Address 5
15 The walk
Yorkshire
England
10 Scottish
Scotland
10 The walk Germany
France
Country
Demonym
Status
England
English
Good
Scottish
Scotland
Bad
Germany
German
Indifferent
What I need to do is find if any of the countries or there Demonym appears in address line 1-5, and then match that to there status.
so for the above I would expect it to find England in address line 3 and output the status good, I would expect it to find Scottish in address line 1 and Scotland in address line 2 and output the status bad. And i would expect it to find Germany in address line 1 and output the Status Indifferent.
Couple of Issues been that I do not produce either of the excel sheets so there format is what I am stuck with and the amount of countries on sheet 2 is completely random and can be updated at any point. Finally I need to have a full register of sheet 1 without any changes made to it loaded into qlikview so I am unable to do the checking through the load function.
I think Stefan's solution should have the better performance with your larger tables, so maybe you give it another try with the additional MAP name like suggested.
