Parsing single CSV file (input) into multiple CSV files, using a specific field

[Jake5]

Using the attached csv input, I am trying to get my workflow to parse into multiple csv files using LASTDATEINPERIOD as my group by selection.  Since there are 14 unique dates in this column, I would expect 14 output files which I'm getting, each distinguishable by adding the date to the end of the file output name.  However, when I run the workflow (also attached), it's not returning the actual records associated with the LASTDATEINPERIOD.  I've attached one of the 14 outputs for reference.  Any advice on what tweaks to make to get this to work?  

[abacon]

@Jake5 Because you are using the Table tool, you have to use the Render output tool, not the regular output data tool. Here is an update to your workflow that writes to XLSX files (CSV isn't supported with the render tool).

Bacon

[Jake5]

Yea, I had tried the render tool previously and noticed no .csv option which is why I scrapped the idea.  It's interesting that .csv is available as an output format for the standard output tool but is unable to parse this way.  CSV output is important to this process and having to do a save as to csv is not ideal.  

[abacon · Accepted solution]

@Jake5 An option would be to send to xlsx, then use a python script to convert the xlsx files to CSV.

Unfortunately, if you want to use the table tool, you will have to use a render to output the data.

Bacon