Recently I was given a list of patients and asked to add a new column to the list containing each patient’s entire set of secondary diagnoses. All secondary diagnoses needed to appear in a single column on the same row with a comma between each distinct diagnosis.
Concatenate Multiple SQL Server Columns into a Single Column
November 25, 2018
Highcharts Drilldown Examples
November 13, 2018
Multiple level drilldown examples in an easy-to-follow format.
U.S. States in Multiple File Formats
May 28, 2018
I was recently working on a data mining project where I had to clean millions of street addresses. One thing that got old fast was stopping my work to search the Web for a clean list of U.S. states (plus territories) in a particular format. So I made my own set and posted it here so that you and I never have to endure that annoyance again.
An Easier Way to Understand Excel INDEX/MATCH Formulas
April 24, 2018
At least once a month I use an INDEX/MATCH formula to match and merge patient data from multiple Excel files. I wrote this post because when I first sought to learn the technique I found the other tutorials on the web difficult to follow or understand. This is my attempt at more intuitive explanation.
How to do Percentile Ranking in Oracle
March 13, 2018
Recently I had to provide a script to convert a dataset of raw assessment scores into an Oracle table with the scores ordered by percentile rank. This is a common request so I figured a short, non-technical post on percentile ranking might be helpful to a lot of people.