Pascal Bellerose on 06 Apr 2020 20:10:55
In Power Query, I never understood the logic behind the usage of single usage objects and have it store its result and make it reusable throughout the script.
It leads to problems when changing source's format.
I'm thinking about switching back to R for data transformation.
I have been working on a data transformation script that I now have to rebuild from scratch because I keep getting an error about the file format (caused by using 64 bit version with 32bits excel files).
I'm pretty sure that if it was a real scripting environment with variables declaration and proper memory management, we wouldn't end up in this situation.