Load data from from two tables

[#1]

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

[CELAMBARASAN]

Hi

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

[jagan]

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.

[sasiparupudi1]

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

[muthukumar77]

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;