topic Adding values to existing column in load in QlikView

Adding values to existing column in load

pauldamen — Tue, 11 Aug 2015 14:28:00 GMT

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

Re: Adding values to existing column in load

Anonymous — Tue, 11 Aug 2015 14:32:06 GMT

Hi Paul,

Please post sample data so can help.

Regards

Neetha

Re: Adding values to existing column in load

Anonymous — Tue, 11 Aug 2015 14:33:03 GMT

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

concatenate them from your second table ??

Re: Adding values to existing column in load

maxgro — Tue, 11 Aug 2015 14:34:28 GMT

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;

Re: Adding values to existing column in load

pauldamen — Tue, 11 Aug 2015 20:56:25 GMT

Thanks Massimo!

Re: Adding values to existing column in load

qlikviewwizard — Wed, 12 Aug 2015 06:17:28 GMT

Good explanation Massimo.Thank you.