Default Include or Exclude New Columns in KNIME

It’s common when creating a new workflow that after the flow is finished the source data can change. The most common scenario is when connected to a database table or view and the data gets extra columns added. In this scenario you need to make sure that your workflow doesn’t break caused by the introduction …

Getting OP_RETURN Bitcoin Messages

This is mainly a note to myself as every time I want to do this I end up searching through my history doing something like this. So here’s the code to extract the OP_RETURN message from the bitcoin blockchain. This needs to be run on the machine running your full node. The output looks like …

Compound Improvements

The easiest way to earn money, improve a product or learn new skills is very simple. Compounding. If you invest money today in an Index fund and just leave it for 30 years you’ll probably be shocked how little it increases in the first 20-25 years and how much it increases after that. Even a …

Common Data Mistakes

This isn’t meant an an exhaustive list but just the most common errors I’ve seen over the years. Taking the average of values that are already an average Trying to join database tables on fields with different data types Processing data you will later discard, do filtering early on Using averages when mean or mode …

Money As Data

Current ‘Digital’ Money As much as many people use banking apps and send money via their smartphones, money isn’t really digital yet. What do I mean by ‘not digital’? Of course it doesn’t mean you need to physically transfer paper money and metal coins to buy a coffee. You can of course do this digitally …

Delete Files Using Alteryx

Yet another custom tool for Alteryx to fill a hole in the file handling capabilities without resorting to using the Run Command tool. Available to download and install from Github (https://github.com/bobpeers/Alteryx_SDK_Delete) or you can grab a sample workflow including link to the tool from the Alteryx Public Gallery (https://gallery.alteryx.com/#!app/File-Delete/5f4770d8826fd309c4f9e427) The tool uses the standard Python …

Credentials – Custom Alteryx Tool

Why Saving Credentials is Hard 🔐 Saving credentials for use in an Alteryx workflow is a very common use case. Maybe you use an API and need to save Client keys or secrets and getting these credentials into a workflow without hard coding is tricky. It’s common to either read from a text file located …

Custom Alteryx Tools

So far I’ve written four Alteryx tools based on the Alteryx Python SDK. You can install by downloading the yxi file under the releases tab in GitHub and simply double click to install. The tools will be available in the Alteryx Tool menus and function just like the built-in tools that ship with Alteryx. Data …

File Hashing in Alteryx

Identifying Duplicate Files Imagine you have a folder full of files, all with different names, where you need to identify which, if any, are duplicates. You could use the file size but it’s not a guarantee the files are exactly the same just because they are the same size. Hashing files is an easy way …

You Should Probably Learn To Code

There’s been a clear trend going on for many years now known as ‘No code’ or ‘Low code’. This essentially describes tools or platforms that provide you with a GUI that abstracts away the underlying technicalities so non-technical users can use powerful software. Doing this has been a huge benefit to business since the addressable …