Month: March 2013
-
PyCon tweet proves email is not worst form of communication
I have long thought that email was the worst form of communication; primarily because it involves no real conversation, only the author giving his views to the recipient. But Adria Richards, who in her own words is a “Joan of Arc” like figure has proved me wrong. The feminist Ms Richards was offended by the…
-
Create the Union of two tables in Excel
— 2017-04-03 I have new post for Excel 2016 (2013) — It is very common in Excel to need to create a single table from the two or more other tables. For example, different users may edit different worksheets but you need to aggregate all the data for processing. This can be done relatively simply…
-
How to add a row number to an Excel table
Excel tables provide a lot of support for data processing and the use of structured references can improve readability. We want to number rows in an Excel table and we can do it really easily using structured references. =ROW(Table01[@])-ROW(Table01[[#Headers],[RowId]]) We simply find the row number of the current cell [@] using ROW and then subtract…
-
A T-SQL SPLIT function
When taking existing data to put into a data warehouse one hopes that it is nicely formatted. This is seldom the case and recently I was faced with the problem that single field contained a rather dirty list. First I cleaned the list using REPLACE to replace the variety of delimiters with comma. Then I…
Dr James Bayley 