Can I pass in dynamic file name?

shiloh.jordan Oct 25, 2017 12:34 PM

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?

rareddy Oct 25, 2017 1:25 PM (in response to shiloh.jordan)

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.
Actions