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?

pluis Beginner Asked on July 24, 2019 in Diyotta Studio.
Add Comment
1 Answers

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.

Expert Answered on July 24, 2019.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.