Logic to generate output files dynamically

[Developer9]

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

[chulett]

Code: Select all

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

[chulett]

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

[Developer9]

@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

[ray.wurlod]

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.

[Developer9]

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

[chulett]

Your Moderator thanks you.