topic how to use mapping table if there is a loop? in QlikView

how to use mapping table if there is a loop?

Tue, 26 Jan 2010 07:00:50 GMT

Hi All,

I'm not sure if this is a product limitation or bug.

i have a for loop to reload data for next database which will store qvd in another folder.within this for loop, i'm using a mapping table and applymap function.

When i use applymap, the value is not map as it supposed to be when i loop 2 databases. if i just use 1 db at a time, it's ok.

i can't drop a mapping table before the next command. is there a workaround for this? Doing a left join will be slow.

Any idea is very appreciated. Thanks!

how to use mapping table if there is a loop?

Tue, 26 Jan 2010 20:33:03 GMT

Is the mapping load statement outside or within your for-loop?
If it's inside the loop I guess it could mean trouble since you will be creating the same table over and over again. Not sure really what the result of such on operation would be.
If this is your case, try adding a variable counter to the mapping table name.
Something like this maybe (untested):

set counter = 0;
for x = 0 to 10
set counter = counter + 1;
map$(counter):
mapping load ....
load applymap('map$(counter)', field, defaultvalue) as mapField ....
next

how to use mapping table if there is a loop?

Sat, 30 Jan 2010 12:57:58 GMT

thanks fredrik! it works!