Comments
-
Thanks to both of you fellas! I totally forgot about the DomoStats dataset, I'll be going with that solution. :)
-
Thank you for the response! Unfortunately we need to keep our store numbers formatted as text for this dataset and preceding zeros may alter downstream ETL's, so I'm not sure either of those two particular solutions will work for the time being.
-
@MarkSnodgrass Do you have an explicit example of what type of data would be problematic for an .xlsx export but not .csv? Maybe an entry with lots of spaces or tabs? I just recreated the card from scratch and am getting the same error when exporting. This is a mega table card with 99 columns that is transposed in the row…
-
@jaeW_at_Onyx they are QuickBooks jobs meant to generate different accounting reports. Thank you @GrantSmith , it sounds like what I'm trying to do isn't exactly accomplishable.