topic Re: Script help in QlikView

Script help

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I have 3 tables

Owner:

RecordOwner,

...;

Inv:

Id,

RecordOwner,

....

...;

NC:

Id,

RecordOwner,

....

...;

Below is my condition.

If(RecordOwner(in Owner Table) = RecordOwner ( in Inv Table) , Load "Id" data in Inv Table,

If(RecordOwner(in Owner Table) = RecordOwner ( in NC Table) , Load "Id" data in NC Table)

In my original script this condition is not included..

original script is as below.

NC:

Id,

RecordOwner,

....

...;

Left Keep(NC)

Inv:

Id,

RecordOwner,

....

...;

Left Keep(NC)

Owner:

RecordOwner,

...;

Please help.

Thanks,

Raghav

Re: Script help

mdmukramali — Tue, 16 Jan 2018 05:39:22 GMT

Hi ,

if you want to Keep Those Tables Separate without any Joins then you can use Where Exist function in the below two tables.

but before that i would like to see the all the fields from 3 tables because to check what are the comman fields between those tables.

attach the script or screen shot.

Thanks,

Mukram

Re: Script help

avinashelite — Tue, 16 Jan 2018 05:41:09 GMT

Try like this

Owner:

LOAD

RecordOwner,

RecordOwner as KEY,

...;

Inv:

LOAD

Id,

RecordOwner,

....

...

where EXISTS(KEY,RecordOwner);

NC:

LOAD

Id,

RecordOwner,

....

where EXISTS(KEY,RecordOwner);

Re: Script help

Anonymous — Tue, 16 Jan 2018 05:44:19 GMT

Hi Mohammed,

fileds which i mentioned are the only common fields. Rest all fields are used only for analysis.( they are no way related to each other)

can you please provide sample script as per your reply.

my requirement : base is RecordOwner from that

If(RecordOwner(in Owner Table) = RecordOwner ( in Inv Table) , Load "Id" data in Inv Table,

If(RecordOwner(in Owner Table) = RecordOwner ( in NC Table) , Load "Id" data in NC Table)

Re: Script help

Anonymous — Tue, 16 Jan 2018 05:45:23 GMT

for below dont we need any Join condition>?

Inv:

LOAD

Id,

RecordOwner,

....

...

where EXISTS(KEY,RecordOwner);

NC:

LOAD

Id,

RecordOwner,

....

where EXISTS(KEY,RecordOwner);

Re: Script help

karthikoffi27se — Tue, 16 Jan 2018 05:47:55 GMT

Hi Raghav,

you can try using where exists function.

NC:

Id,

RecordOwner,

....

...;

Left Keep(NC)

Inv:

Id,

RecordOwner

Where exist (RecordOwner)

....

...;

Left Keep(NC)

Owner:

RecordOwner

Where exist (RecordOwner)

Many Thanks

Karthik

Re: Script help

avinashelite — Tue, 16 Jan 2018 06:23:20 GMT

not required this is more efficient way to handle this scenario

Re: Script help

Anonymous — Tue, 16 Jan 2018 07:24:23 GMT

This is exact requirement on which app needs to be built. Please help.

If the id # (from, Inv table ) is missing, then record owner name comes from the NC. Else, the record owner name comes from the inv.