DSXchange

Posted: **Tue Aug 02, 2016 6:33 pm**

Hi ,
I have a requirement to generate output files based on the division Grouping populated in a table (group numbers subject to change depends on change in the data)

Code: Select all

Group| Division
1	5
2	5
3	5
N   5
1	25
2	25
3	25
4	25
5	25
6	25
7	25

Output :

Code: Select all

Division 5-File 1,File 2 ,File3 ..FileN
Division 25-File1,File2,..File7

Design Tested

Code: Select all

File/Table (read group,division) --->filter criteria (division,group) -->file1,file2 ..fileN

This will be only work if Group numbers are constant but for dynamic group numbers how can we implement logic to split files

Please let me know your ideas to implement logic for this scenario

Posted: **Tue Aug 02, 2016 8:13 pm**

Code: Select all

[/b] tags, not [b][quote][/b] tags for things of this nature. Fixed for you.

Posted: **Tue Aug 02, 2016 8:17 pm**

Upgrade to at least 9.1 and that functionality is built into the Sequential File stage.

Posted: **Wed Aug 03, 2016 12:45 pm**

@Chulett,

At my place we might move to 11.5 but not immediately until then I need to build the logic in place to support this task.

Thanks

Posted: **Wed Aug 03, 2016 3:43 pm**

Use a server job and the Folder stage. If you are required by internal politics only to have parallel jobs, put the Folder stage in a server Shared Container and use that Shared Container in your parallel job. The Folder stage has the capability you are seeking.

Posted: **Wed Aug 17, 2016 3:26 pm**

Thank you all for the input ..There was a requirement change holding off my testing ..still want to test this scenario

I am creating a new post for the new requirement

Posted: **Wed Aug 17, 2016 3:47 pm**

Your Moderator thanks you.

DSXchange

Logic to generate output files dynamically

Logic to generate output files dynamically