Post #2312792
2026-05-08 02:26 UTC
@LeafyEricScott@hachyderm.io if you do not need column 3, I would `cut` in shell it before reading the csv.
Replies (1)
-
@cd_newton@hachyderm.io 2026-05-09 16:09
@defuneste@fosstodon.org @LeafyEricScott@hachyderm.io *EDIT* sorry I missed that someone already suggested this! I know “regular” DuckDB has the “Union by name” argument in read_csv() which might work, I’m not sure the R package version of read_csv() lets you use this, but presumably you could use the SQL syntax within dbGetQuery() and that might work? 🤔 https://duckdb.org/docs/current/data/multiple_files/combining_schemas