Try before you error

Try before you error

Problem to solve: importing many files into Power BI where some are not complete and trigger an ODBC error.

While importing thousands of JSON files I bumped into the situation where some of the files weren’t following the structure and thus caused an error and the import process to stop. The files were supposed to have some general and customer information about an order and order lines structured under “lines”.

Lees verder

Getting to know my computer

Problem to solve: fast find occurences of a string in thousands of files on a Windows computer

The first computer I ever worked with was the Mac SE, small, heavy, loud, with a nice graphical user interface. When I decided to follow a computer class, the first screen I saw was black with a nice c:\>. I thought the computer was broken. Windows 3.1 was yet to come. I never paid much attention to all the possibilities Windows offers nowadays until a few days ago.

Lees verder