Loading script

[arsenal1983]

Hello,

I have one table with invoice data (date, ivoice no, amount) and I would like to import another one (with some other information) but only for these documents that are in first table.

How can I do this?

Luke

[Gysbert_Wassenaar · Accepted solution]

Use a left join or a left keep:

Table1:

LOAD Key, a,b,c FROM source1;

left keep

Table2:

LOAD Key, c,d,e FROM source2;

See this document for more information: Understanding Join, Keep and Concatenate

[maxgro]

T1:

load

     date, [ivoice no], amount

from

     source1;

T2:

load

     [ivoice no],

     field1, field2, field3

where

     exists([ivoice no])

from

     source2;