search

nadiabey / dukehub

0 stars 0 forks source link

Merge.sql #1

Open nadiabey opened 2 years ago

nadiabey commented 2 years ago

Including all departments in one table is not practical as it takes forever to load in SQLite3 and forever to output to a CSV. Each department will just have to be output to its own CSV similar to earlier iterations.

nadiabey commented 2 years ago

All table will be merged to create views (for earliest closure, etc.). Tableau does not use .db files so I will either have to merge all the CSVs in Tableau Prep, try to output to a big CSV anyway, or do separate CSVs and just work through all of them manually. [my longest sigh ever]