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 …
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 …
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 …
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 …
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 …
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 is very flexible when it comes to connecting to data. Connect to any data source accessible by ODBC, cubes (both SSAS and Orcale Essbase), …
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 …
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
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! …
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 …