Re:Excel is pretty dang cool
by layer8 on Friday August 12, 2022 @06:41PM
(#32444828)
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. Also, EDT doesn‘t look like it can do joins?
[ Parent
| on HN ]
Re:Excel is pretty dang cool
by hermitcrab on Saturday August 13, 2022 @03:31AM
(#32447692)
>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).