Qlik Community

Qlik Education Discussions

Discussion Board for collaboration related to Qlik Education.

arsenal83
Contributor

Loading script

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

1 Solution

Accepted Solutions

Re: Loading script

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


talk is cheap, supply exceeds demand
2 Replies

Re: Loading script

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


talk is cheap, supply exceeds demand
MVP
MVP

Re: Loading script

T1:

load

     date, [ivoice no], amount

from

     source1;


T2:

load

     [ivoice no],

     field1, field2, field3

where

     exists([ivoice no])

from

     source2;

Community Browser