Assure DQ

Welcome to the Assure DQ community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Here are some useful links where you can find more information:

Product Announcements  Product Documentation  Ideas Portal

Discussions

Members

Resources

Events

 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: