topic Re: need help in QlikView

need help

Wed, 25 Nov 2020 16:16:04 GMT

Hello viewers.

I have a mapping table(.xls)&master table(.qvd) it contains

mapping:

com_name, code

ihp, 001

ics, 002

itech, 003

icl, 004

master:

ouname, f2, f3, f4, f5

ihp,

ics,

itech,

icl,

ghp,

gcs,

gtech,

gcl

Now my requirement is

to compare mapping table with master table

If any new record is found then it will automatically load into mapping table

My script looks like

In master I have renamed ouname as com_name

mapping:

Load

companyname,

code

from<>;

concatenate

load

com_name

resident master

where not exists(com_name);

But it is not showing desired output.

My desired output should be like this

com_name, code

ihp, 001

ics, 002

itech, 003

icl, 004

ghp

gcs

gtech

gcl

any Help will be appreciated.

Re: need help

devarasu07 — Thu, 20 Apr 2017 18:05:00 GMT

Hi,

Try to keep same field name (com_name) on both table and your script should be ok.

mapping:

load * Inline [

com_name, code

ihp, 001

ics, 002

itech, 003

icl, 004 ];

Concatenate(mapping)

//master:

load * Inline [

com_name, f2, f3, f4, f5

ihp,

ics,

itech,

icl,

ghp,

gcs,

gtech,

gcl

] where not Exists(com_name);

Re: need help

Fri, 21 Apr 2017 01:40:56 GMT

That is working fine

But in the existing table we have field name as ouname and In other table field name com_name

I don't have permissions to modify the existing data.

In application, I have renamed ouname as com_name

In this case how to accomplish this???

Re: need help

qlikview979 — Fri, 21 Apr 2017 05:50:43 GMT

may be try like this

T1:

LOAD ouname as com_name,

f2,

f3,

f4,

FROM

(ooxml, embedded labels, table is Sheet3) ;

T2:

LOAD com_name,

code

FROM

(ooxml, embedded labels, table is Sheet2)where Exists(com_name);

Re: need help

Prabhu — Fri, 21 Apr 2017 06:06:44 GMT

Mention both actual name and alias name. Ex: Where not exists(com_name, ouname)

Also, ensure that the field name is same in both tables.