SQL Server PIVOT and UNPIVOT – with Sample Code
This article will go over how to transform distinct column values into columns and transform columns into distinct column values using the PIVOT and UNPIVOT function. There are 2 different ways to use these functions – static and dynamic. The static approach is used when the distinct columns or column values are known. If the […]
How to Perform Data Validation in QlikView
As with any BI tool, developer validity testing needs to be performed prior to any and all releases of an application to the end users. BI tools, like QlikView, allow for the rapid development of an application giving results very quickly. This rapid development is wonderful to help see results and make decisions…. but a […]