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?
Use a left join or a left keep:
LOAD Key, a,b,c FROM source1;
LOAD Key, c,d,e FROM source2;
See this document for more information: Understanding Join, Keep and Concatenate
date, [ivoice no], amount
field1, field2, field3
Retrieving data ...