• Ask a Question
  • Create a Poll
150
Insert Image Size must be less than < 5MB.
    Ask a Question
    Cancel
    150
    More answer You can create 5 answer(s).
      Ask a Poll
      Cancel
      Beginner

      RE: How can I specify a pattern to pick and read a file without specifying the full file name?

      My source system send me a file daily but each day the name of the file is appended with the date on which it’s send, like <source system name>_mmddyyy. How can I specify only the first part of the name excluding the date part so that the file is picked up and processed?

      Asked by pluis on July 24, 2019 in Diyotta Studio.
      1 Answers
      Expert

      This can be achieved in multiple ways using parameterization concepts for file name based on the exact requirement. Below is an basic solution to achieve it,

      1. Create a dataflow with File as a source and required database as a target.

      2. Select File source instance in dataflow and click on ‘Extraction Properties’ tab in design tab.

      3. Give ‘File Name’ with pattern as only source system name_* and choose ‘File data reference’ as wildcard.

      RE: How can I specify a pattern to pick and read a file without specifying the full file name?

      4. Execute the dataflow.

      5. Further it can be scheduled in schedular module to trigger dataflow automatically everyday.

      Answered by Srinithya Chikyala on July 24, 2019..