4 Replies Latest reply: Jul 11, 2016 8:47 AM by Mike Hillcoat RSS

    Field from first table into Filepath for new table

    Mike Hillcoat

      Hi all,

       

      I want to be able to open a table based on the field that is pulled from a separate table, but am having no luck figuring it out. Any help would be appreciated.

       

      Here's the example:

       

      Calendar:

      LOAD *,

        @1 as Date,

        textbetween(@2,' ','day')&textbetween(@2,' ',' ',2) as File

      FROM

      [H:\calendar]

      (txt, codepage is 1252, no labels, delimiter is ';', msq);

       

       

      Data:

      LOAD *

      FROM

      [H:\File]