SQL create a delimited string from a flat file
Recently I wrote a post on how to split a delimited string in SQL. Now I need to do the reverse and take the flat …
SQL split string by a delimiter to create new rows
Ever need to split a delimited string in SQL, creating new records? For example you could have a table called Users: Country User UK Bob|Fred|Bill …
Tableau Extracts are Slow to Refresh on the Server
Do you sometimes find Tableau data extracts are slow to refresh on the Tableau Server? Is your extract taking too long and not refreshing? Usually …
Custom SQL data connections in Tableau
Using custom SQL in a Tableau data connection can cause unexpected errors. There are many different flavours of SQL, and they don’t share the same …
Excel Populate a Combo Box from a Database
To populate a combo box on a userform in Excel you need to use VBA. Firstly add a combo box to a userform in the …
Tableau Connecting to Data
Tableau is very flexible when it comes to connecting to data. Connect to any data source accessible by ODBC, cubes (both SSAS and Orcale Essbase), …
Remove a line feed / carriage return from a string
This article describes how to remove the carriage returns and line feeds in SQL, Tableau, Excel and Access. If you ever have to deal with …
Adobe Analytics (Omniture) visits report in Tableau
I tried to recreate the Google Analytics visit chart in Tableau, in the style of the Adobe Analytics (previously Omniture) visits report. I like the …
Read moreAdobe Analytics (Omniture) visits report in Tableau
Tableau DateAdd in Custom SQL Data Connection
The syntax of DATEADD in Tableau Custom SQL differs to the syntax of DATEADD in a Tableau calculated field. This can and does cause confusion! …
SQL Calculating the row number
To label the row number in SQL there’s a useful SQL function you need to know about: ROW_NUMBER() As the name suggests, it numbers all …