Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 '~');
Use Noram Sql Join
like
Load * from ABC
Left Join XYZ;
hope it will work
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