topic Re: Load data from from two tables in QlikView

Load data from from two tables

Thu, 29 Sep 2016 09:19:12 GMT

I need to pick specific order lines within an order number.

Table1:

Load

[Enumber]

Resident Invoices where [MqatNr]='D102326';

Table2:

Load

[Enumber],

[MaterialNr], as [Mtrl],

[InvoiceText] as [FText]

Resident Table1 where [ProdH_L1]='11' and [Enumber]=[Enumber].Table1:

It´s the bold part at the end of the last line i cannot get working.

kindly

Håkan

Re: Load data from from two tables

CELAMBARASAN — Thu, 29 Sep 2016 09:28:05 GMT

there is a function called Exists which will look for values already loaded in the fieldname in other tables that are already loaded.

Table1:

Load

[Enumber]

Resident Invoices where [MqatNr]='D102326';

Table2:

Load

[Enumber],

[MaterialNr], as [Mtrl],

[InvoiceText] as [FText]

Resident Table1 where [ProdH_L1]='11' and Exists([Enumber]);

Make sure no other table previously loaded doesn't have the field [Enumber] except Table1

Re: Load data from from two tables

jagan — Thu, 29 Sep 2016 09:34:38 GMT

Hi,

You can try using Exists() like below

Table1:

Load

[Enumber]

Resident Invoices where [MqatNr]='D102326';

Table2:

Load

[Enumber],

[MaterialNr], as [Mtrl],

[InvoiceText] as [FText]

Resident Table1 where [ProdH_L1]='11' and Exists([Enumber]);

OR you can use Left Keep like below

Table1:

Load

[Enumber]

Resident Invoices where [MqatNr]='D102326';

Table2:

LEFT KEEP(Table1)

Load

[Enumber],

[MaterialNr], as [Mtrl],

[InvoiceText] as [FText]

Resident Table1 where [ProdH_L1]='11' ;

Hope it helps you.

Regards,

Jagan.

Re: Load data from from two tables

sasiparupudi1 — Thu, 29 Sep 2016 09:53:54 GMT

Use ApplyMap ..

[Map Table]:

Mapping Load

[Enumber],

1 as Flag

Resident Invoices

where [MqatNr]='D102326';

Table2:

Load

[Enumber],

[MaterialNr], as [Mtrl],

[InvoiceText] as [FText]

Resident Table1

where [ProdH_L1]='11'

And ApplyMap('Map Table',[Enumber],0)=1;

HTH

Sasi

Re: Load data from from two tables

muthukumar77 — Thu, 29 Sep 2016 11:38:17 GMT

Hi,

Table1:

Load Distinct

[Enumber]

Resident Invoices where [MqatNr]='D102326';

Table2:

Load

[Enumber],

[MaterialNr], as [Mtrl],

[InvoiceText] as [FText]

Resident Table1 where [ProdH_L1]='11' and Exists([Enumber],[Enumber]);

Drop table Table1;