Mapping table

bobbydave — Wed, 25 Nov 2020 16:16:04 GMT

I just know there is gonna be a simple answer to this but my brain aint functioning today.

I have a mapping table that maps countries and country codes to tables.

I have a loop that goes through each of my tables and maps each country.

All good .. coz it goes and maps each country.

However, in my second mapping table which is more or less going to do the same functionality, I only want to bring in 3 countries of this mapping table FR, PO and NL

Countries:

LOAD Code,

Country,

Region

FROM

[$(vMapping)\Mappings_Tia_AXA.xlsx] (ooxml, embedded labels, table is [TIA Countries])

Where Match(Code, 'FR', 'PO', 'NL')=0

;

I only want to return those 3 countries; otherwise, it will return all the countries from AT (Austria) ........UK.

i only want those 3 countries to be return for my mapping table and then it will go into the loop

LET country_count = FieldValueCount('Code');
TRACE $(country_count);
for i=1 to $(country_count) // loop through every country

let country_code = FieldValue('Code',$(i)); //get country code
TRACE $(country_code);

MyTable:

Next; // to loop back and grab the next country.

Any help for a rather dumb question (my brain is just fuzzy today)

Re: Mapping table

bobbydave — Wed, 07 Jun 2017 14:53:34 GMT

Removed the =0

working

topic Re: Mapping table in QlikView

Mapping table

Re: Mapping table