Assure DQ

 View Only
  • 1.  Dynamic File Name

    Employee
    Posted 02-21-2020 13:48

    Hello,

     

    My source file is a CSV file. and the file naming convention is ab_xyz_yyyymmddhhss.csv. So the file name changes everyday. How can I build a layout for such files?



  • 2.  RE: Dynamic File Name

    Posted 02-21-2020 14:12

    Hi Manish,

    You can leverage Assure’s File Monitor feature for this. File Monitor will dynamically find files to process based upon file name patterns. At a high-level, a File Monitor control is a control that will monitor a specified directory for files that matches its pattern. Those file names are picked up as standard Control Fields, which can be passed via Actions to trigger your desired control. The action would need to override the input source location with the dynamically captured input source location, giving you the ability to run controls without knowing the exact input name ahead of time.

     

    There’s also a sample File Monitor control that can be built within Assure via the Rules > Express > Input Files Control option: