topic joining textfiles in QlikView

joining textfiles

qlikhans — Fri, 04 Feb 2011 16:39:23 GMT

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 — Fri, 04 Feb 2011 16:44:42 GMT

Use Noram Sql Join

like

Load * from ABC

Left Join XYZ;

hope it will work

qlikhans — Fri, 04 Feb 2011 19:24:51 GMT

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