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

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?

CSV Workflow.yxmd

HOSTPACSF529FANDR.csv

HOSTPACSF529FANDR1_31_2024.csv

Data Investigation

Accepted answers

abacon

@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

All comments

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

CSV Workflow.yxmd

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.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703