Assure DQ

 View Only
  • 1.  Dynamic input file name with the sysdate

    Employee
    Posted 03-02-2021 18:25

    Infogix Community ,

    We are getting a file from an external system every day. The file name will be in the format of abc_yymmdd.txt. That means the file name is changing every day. How do I configure the file layout the read the file dynamically? 



  • 2.  RE: Dynamic input file name with the sysdate

    Employee
    Posted 03-04-2021 13:18

    This can be accomplished via the File Monitor feature. At a high-level, this is a control that would run frequently, typically every few minutes, and its input is a directory on your filesystem. Instead of capturing file data, it captures information around the files themselves based on inclusion/exclusion rules within the control. Generally the filenames are extracted and are sent to a second control to process the content of the file found. This allows for files with dynamic names to get captured without updating logic. 

    Within the Assure's in-product help (Help > Launch Full Help), there's more detailed instructions on using this feature under the "File Monitor Controls" and "Input Files Express" pages.