Splitting file into smaller output files by "Months"

[darenson]

I am working with volume data that runs to be in several million records and I was hoping to create an output that can be split into multiple files and each file consisting of that month.

Here is a simplified example of this:

Master File:

Facility	Qty	Month
A	1	4
A	67	5
B	45	4
B	1233	4
B	4332	5
A	23132	3
A	1	4
B	4	5
B	534	4
A	3213	3
A	34	5
A	8645	5
B	200	3
B	321	4
B	2131	4
B	23189	3

So this would be broke down into 3 files:

File 1:

Facility	Qty	Month
A	23132	3
A	3213	3
B	200	3
B	23189	3

File 2:

Facility	Qty	Month
A	1	4
B	45	4
B	1233	4
A	1	4
B	534	4
B	321	4
B	2131	4

File 3:

Facility	Qty	Month
A	67	5
B	4332	5
B	4	5
A	34	5
A	8645	5

Obviously this would be on a much larger scale, but wanted to see if anyone had any thoughts with how to approach this. Thank you!

[AndrewS · Accepted solution]

Hi @darenson 

You need to config the output to group on the Month. Screenshot & workflow attached.

[darenson]

Hi @AndrewS,

This seems to just be a regular output of 1 file. I would need this be 3 separate files like the example I noted above. The goal is to create a separate file for each month.

[AndrewS]

Hi @darenson 

I've run that workflow and it is generating 3 files using the month. Are you able to share your output or workflow?

[darenson · Accepted solution]

Nevermind, you are correct, it pops up in separate files on my server. I thought it would populate as 3 separate files in the workflow. It seems to be working, thanks!!

[AndrewS]

That looks OK, what does the log show?

EDIT - ignore, saw your post above, good that it works. Cheers.