joining textfiles

[qlikhans]

Hi there,

suppose I have something like below and i want to left join these textfiles, anyone can tell me what the syntaxis should be?

thanks in advance

hans

load artnum

FROM R:\Home\rapport\verkoop\data\artikelen.txt
(txt, codepage is 1252, embedded labels, delimiter is '~') ;

load artnum

FROM
R:\Home\rapport\verkoop\data\facturatie.txt
(txt, codepage is 1252, embedded labels, delimiter is '~');

[srinivasa1]

Use Noram Sql Join

like

Load * from ABC

Left Join XYZ;

hope it will work

[qlikhans]

Hi srinivasa1

would it be possible to make your answer copy/pastable idiot proof based on the data presented in my query?

t.i.a.

Hans