Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
Removed the =0
working