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.