This message was deleted.
# helps
Slackbot
06/21/2023, 3:55 PMThis message was deleted.
z
Zach Bogart
06/21/2023, 4:01 PMIt seems to be working for the example
penguinsf
Fabian Iwand
06/21/2023, 4:09 PMThe CSV option is not available if your data contains anything but scalar values (strings, numbers, bools) and dates.
✅ 1
a
Aldo Viramontes
06/21/2023, 4:17 PM@Fabian Iwand I see, I have a column with arrays. I've been searching for notebook that implements "csv downloader", but haven't had any luck. Any chance you know of any?
f
Fabian Iwand
06/21/2023, 4:20 PMAre you looking for one in general, or as a means to work around this limitation?
Fabian Iwand
06/21/2023, 4:21 PMhttps://observablehq.com/@mootari/export-duckdb supports CSV exports.
🙌 1
m
Michael Cooper
06/21/2023, 5:43 PMhow would you expect arrays to show up in a CSV?
a
Aldo Viramontes
06/21/2023, 6:09 PMThank you, @Fabian Iwand!
Aldo Viramontes
06/21/2023, 6:10 PM@Michael Cooper, since the person I'm sending the .csv file to is an excel user, as comma separated values within a cell:
f
Fabian Iwand
06/21/2023, 6:12 PMI think those are thousands separators, not comma separated values?
a
Aldo Viramontes
06/21/2023, 6:15 PMSorry I'm not able to share the notebook because of the data source (work-related), but they are not thousand separators:
👍 1
m
Michael Cooper
06/21/2023, 7:01 PMMy question was actually sort of leading: What I mean to say is that the format of a cell that contains an array is not defined by CSV, and so we can't have a generic export to CSV-with-arrays. You'd have to know your expected consumer, and work towards that.
Michael Cooper
06/21/2023, 7:01 PMIn this case, you could have a calculated field that is
after_values.map(d => d.toString()).join(",")