3 ms·
This is a standard use case for ETL (extract load transform) tools such as Easy Data Transform at the budget end (which i wrote) or Alteryx at the corporate end
by hermitcrab 4y ago
This is a standard use case for ETL (extract load transform) tools such as Easy Data Transform at the budget end (which i wrote) or Alteryx at the corporate end.
- layer8 4y agoI want the expressiveness of SQL queries within a single Excel file, so that data entry and derived views are within the same tool and same file. Also, EDT doesn‘t look like it can do joins?
- hermitcrab 4y ago>I want the expressiveness of SQL queries within a single Excel file, so that data entry and derived views are within the same tool and same file. There is at least 1 tool that can run SQL within Excel. I forget the name. You can probably find it via Google. >Also, EDT doesn‘t look like it can do joins? Easy Data Transform can absolutely do Joins (plus 58 other transformations).