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:



      LOAD *,

        @1 as Date,

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



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




      LOAD *