2 Replies Latest reply: Feb 4, 2011 2:24 PM by Hans kleijnen RSS

    joining textfiles

    Hans kleijnen

      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 '~');