topic Re: Script calculation issue in QlikView

Script calculation issue

Mon, 03 Aug 2015 15:41:17 GMT

table1:

customerid ,bookingloc, deliverloc

100 1 2

table2:

locid locname

1 bangalore

2 chennai

how i can achieve below output as w/o null records

customerid bookingloc deliveryloc

100 bangalore chennai

Re: Script calculation issue

Anonymous — Mon, 03 Aug 2015 15:44:29 GMT

use applymap:

Table2:

mapping load

locid, locname

from ..

table1:

load customerid,

applymap('Table2', bookingloc) as bookname,

applymap('Table2', deliverloc) as delivername

from

Re: Script calculation issue

marcus_sommer — Mon, 03 Aug 2015 15:45:44 GMT

You could use mapping with applymap() for this, see: Mapping … and not the geographical kind.

- Marcus

Re: Script calculation issue

maxgro — Mon, 03 Aug 2015 15:54:32 GMT

or add a table

table1:

load * inline [

customerid ,bookingloc, deliverloc

100, 1, 2

200, 2, 1

];

table2:

load locid as bookingloc, locname inline [

locid , locname

1, bangalore

2 , chennai

];

table3:

load bookingloc as deliverloc, locname as deliverlocname resident table2;

Re: Script calculation issue

Mon, 03 Aug 2015 17:16:41 GMT

Hi Rudolf,

We don't have Common Key column...How you will map the table....Can you Please explain....

Thanks & Regards

Raja

Re: Script calculation issue

Kushal_Chawda — Mon, 03 Aug 2015 17:44:42 GMT

Do simple inner join

load customerid ,

bookingloc,

deliverloc

From table1

inner join

load locid as deliverloc,

locname as deliveryloc

From Table2

Re: Script calculation issue

Anonymous — Mon, 03 Aug 2015 19:16:16 GMT

that's how applymap works. just test my solution. you donot Need a common key.

you give bookingloc as Input tp applymap and get bookingname,

same with deliverloc

try it

Re: Script calculation issue

Mon, 03 Aug 2015 20:09:15 GMT

Hi,

find the attachment.

Re: Script calculation issue

qlikviewwizard — Tue, 04 Aug 2015 05:00:08 GMT

Good one

Re: Script calculation issue

senpradip007 — Tue, 04 Aug 2015 05:12:06 GMT

Have a look at the attachment. Hope it will help you.

Re: Script calculation issue

MarcoWedel — Wed, 05 Aug 2015 23:28:40 GMT

Hi,

one front end solution without changing your data model could be:

hope this helps

regards

Marco