AnsweredAssumed Answered

data reader file name substitution variable

Question asked by dchand on Feb 28, 2018
Latest reply on Mar 7, 2018 by bbroughton

We have data files to load that have been prefixed by the Business Unit and Month Year e.g. BU123_Jul.17_SalesDat.txt

 

We have corresponding Month and Business Unit entities in the database. These are available as pagers in a screen. I would like to utilise these to dynamically pass the user selections to the data reader (via a procedure) so that the appropriate file can be read.  I know we can use the @USER substitution variable but not sure how to use other entities. I tried using @MONTH but was not successful. 

 

Any suggestions would be appreciated.

 

It would be even better if we could check if the filename exists and return a message if it doesn't.

 

Thanks,

Dinesh

Outcomes