code for multiple flags using appply map

[#1]

Hi Friends,

I am trying to flag a column using two or three other columns like this

35_41,yyy

35-41-03, xxx

35-41-08, xxx

35-42-03-09,zzz

35-42-08,xxx

Can we use apply map here???

Thanks

[avinashelite]

Hi Pavan ,

Try like this:

tablename:

Mapping load Keyfeild,

                      Mappingfeild;

Select * from table;

Load applymap('tablename',match(keyfeild of this table) as feild

select * from Table;

[ngulliver]

Hi, Pavan.

This is bread and butter for applymaps.

If you need help understanding how they work have a look at this blog

http://www.quickintelligence.co.uk/applymap-is-it-so-wrong/

Alternatively, go to http://www.askqv.com/

This website goes through well respected QlikView blogs looking for answers and demos to your questions.

Cheers,

Neil