The python tool in Alteryx is a great resource that I often use but it can easily get very cluttered with lots of reusable code that could easily be moved out and imported as a library. Unfortunately by default you can’t just use the standard import statement since the location of your workflow at runtime …
Continue reading “Loading Private Python Libraries to Alteryx at Runtime”
There are numerous threads on the Alteryx Community where people are asking how to covert xls files to xlsx. The solutions generally suggest one of two approaches, either Read the file in with an Input Data tool then output again in the new format Use the Run Command tool to use an an Excel component …
It’s not immediately clear on Mac OS how to start a Jupyter Notebook if you’re using Anaconda. The actual executable is located at /Users/*YOURUSER*/opt/anaconda3/bin/jupyter-notebook but it can be a pain to either type the full link or even worse start the Anaconda application first just to open a notebook. The easiest way I found is to …
Continue reading “Jupyter Notebook Shortcut on MacOS using Anaconda”
I recently installed Homebrew on my MacBook and immediately hit permissions issues (I’m running Catalina v 10.15.2 (19C57) and it seems permissions are an issue for many apps). Trying to install wget gave this error. If you look at the permissions on the .config folder you immediately see the problem. By default it’s owned by …
Having recently changed jobs to become a Consultant after working 15 years in the Retail Industry I think about this chart a lot. I’m personally at a stage where I think I know quite a bit but I’m mostly overwhelmed by how much more there is to know 🤯 I also need to become more …
Now that my sensors are successfully collecting data and the data is being processed by a Node-RED flow on my Raspberry Pi the final step is to add some persistence to the data. As it stands the data is constantly streaming and being displayed on a dashboard but after that it’s discarded so there’s no …
In the first part I talked mostly about the sensors and the gateway so in this article I’ll show you how to collect, filter and store that data from the sensors. My setup is running locally on my LAN and uses a Raspberry Pi 3B+ to process the data. I’ll be using Node-RED to process …
This post follows on from my S3 post usng Node-RED so you can read that for a brief into to S3. Using S3 with KNIME is extremely easy as there is already an S3 node available to install. Amazon S3 Connection The only node that needs installing is the Amazon S3 Connection. All the other …
Assuming you’ve just bought a new external hard drive or you have one that’s already in use these are the steps you need to take to make it usable with Linux. ⚠️ Be aware that following these steps will reformat the drive causing all data to be permanently erased. You’ve been warned. First connect the …
Continue reading “Format and Mount External Hard Drives in Linux”
