Adding values to existing column in load

[pauldamen]

Hi,

I have a table like this in Qlikview:

Vendor                         Staff                    Activity

-                                   1                         z

-                                   2                          y

-                                   3                          x

-                                   4                         w

-                                   5                         v

A                                   -                         -

B                                   -                         -

C                                   -                         -

Now I have a second table which contains the vendor names (A,B,C) and which Activities they should be mapped to (Z,X,Y etc).

How can I create 1 table where the activity column is completly filled with the activities. I can't concatenate because then the existing Vendor's won't match. I can't map because the activity field already exists and I can't join because both vendor and activity exists so there is nothing to join.

Regards, Paul

[Anonymous]

Hi Paul,

Please post sample data so can help.

Regards

Neetha

[Anonymous]

why don't you drop the vendors A, B and C from above table and then

concatenate them from your second table ??

[maxgro · Accepted solution]

If I understand in the table you post you have the activity null when the vendor is not null (and viceversa)

So, you can map when Activity is null

Map:

mapping load

     Vendor, Activity

from

     secondtable;

load

     Vendor, Staff,

     if(len(trim(Activity))=0,  applymap('Map', Vendor', Activity) as Activity

from

     firsttable;

[pauldamen]

Thanks Massimo!

[qlikviewwizard]

Good explanation Massimo.Thank you.