Skip to main content
Announcements
Do More with Qlik - Qlik Cloud Analytics Recap and Getting Started, June 19: REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
bobbydave
Creator III
Creator III

Mapping table

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)

1 Solution

Accepted Solutions
bobbydave
Creator III
Creator III
Author

Removed the =0

working

View solution in original post

1 Reply
bobbydave
Creator III
Creator III
Author

Removed the =0

working