Dynamically write to and name file
Situation:
Within an Adeptia Process Flow is it possible to dynamically write to, filter and name a file based on a field in the Source?
Normally I would add additional Target Schemas to the data mapping & split the streams.
However in this case, the number of unique values in the “Client” field is subject to change daily.
For Example:
Original File Name – Employee_Report_2012.csv
Rec Name Id Year Client
1 John H 2012 LI
2 Sam F 2012 ME
3 Dave E 2012 ME
4 John D 2012 Z1
5 Sam Z 2012 LI
6 Sam 5 2012 LI
7 John 8 2012 Z1
8 Dave 7 2012 Z1
9 Steve 8 2012 Z1
---------------------------------------------------------------
Output 1 File Name - Employee_Report_ Z1 _2012.csv
4 John D 2012 Z1
7 John 8 2012 Z1
8 Dave 7 2012 Z1
9 Steve 8 2012 Z1
Output 2 File Name - Employee_Report_ LI _2012.csv
1 John H 2012 LI
5 Sam Z 2012 LI
6 Sam 5 2012 LI
Output 3 File Name - Employee_Report_ ME _2012.csv
2 Sam F 2012 ME
3 Dave E 2012 ME
-
Firstly, filter all the values of clients and group them according to client. Then the mapping needs to be executed in loop for the number of clients. Suppose there are four clients then the mapping will be executed four times and it will create separate file for each execution with desired names.
0
Post is closed for comments.
Comments
1 comment