1 Reply Latest reply on Oct 25, 2017 1:25 PM by Ramesh Reddy

    Can I pass in dynamic file name?

    Shiloh Jordan Novice

      Hi all,

      I am using the getTextFiles procedure and TEXTTABLE function and would like to pass in a dynamic file name in without having to create a separate table for every file name.

       

      All of the files that I am trying to pass in have the same source structure

       

      How would I do this?

       

      All help is appreciated

       

      Thanks,
      Shiloh

        • 1. Re: Can I pass in dynamic file name?
          Ramesh Reddy Master

          That can be only possible when you Design using the Virtual Procedure. For example, take the above-generated SQL code, put it inside Virtual Procedure and make the file name as an input parameter. Then you can excute the procedure with different file names. Then you can execute this as

           

          SELECT * FROM (EXEC ...) AS x

           

          to get results.