My company's accounting system outputs reports as .csv. When the csv is greater than Excel's row limit, I have a Workflow (WF) that will input the csv and output separate csvs with max records per file = 1M (I know Excel's limit is slightly more than 1M). The purpose of this is so people at my company can then open the data in Excel and complete their analyses. (I'm sure some of you are shaking your heads - but trust me that this is the best solution that we have available right now).
It's a very simple input/output WF as you can see below.
I want to move this WF onto Alteryx Server so that way a person can just put the csv into the specified GDrive location and then they run the WF themselves, without a Designer license, and they get their files without needing me to do anything. From discussions with Alteryx, we need to move to using the Google Drive Tools instead of the regular Input/Output. I'm on GDrive Tools 1.1.1.
Question: Is there a way in the GDrive Output to set the max records to 1M? I'm not seeing anything obvious.
I also tried a rather silly workaround where I added a Record ID Tool and then a formula to say "if the Record ID is 1-1M, add an '_1' to the file name; if the Record ID is 1M-2M, add an '_2'" etc. That way when I use the GDrive Output, if there isn't a way to specify max records, I'll still get the same results. It works fine with the regular Input/Output Tools but when I add in the GDrive Input/Output, Designer freezes and crashes.
I'm stumped - am I missing something on the GDrive Output? Or does anyone have any ideas for how I can get this to work? Thanks!
