SQL MERGE

When working with tables in SQL, you will inevitably need to combine the contents of two or more tables at some point.  The SQL MERGE statement provides a quick and straight-forward way to accomplish this task.  The SQL MERGE statement performs insert, update, or delete operations on a target table based on the results of … Read more

Qlikview Subfield Function

This post demonstrates the use of the Qlikview Subfield Function.  For my use case, I am loading an Inline table with sample column data, then creating a second table with sample Qlikview Subfield Function use cases, using the LOAD Resident technique. Qlikview Version:  Personal Edition 12.0.20100.0 SR2 64-bit Edition (x64) OS:  Windows 10 From Qlik Help: … Read more

Qlikview Lookup Function

This post demonstrates the use of the Qlikview Lookup Function.  For my use case, I am connecting to SQL Server Express 2014, using the AdventureWorks2012 database.  I connect and pull in the “all_objects” system table, then build a second table using the LOAD Resident technique. Qlikview Version:  Personal Edition 12.0.20100.0 SR2 64-bit Edition (x64) OS:  Windows … Read more

SQL NULL

When working with tables in SQL, you will sometimes encounter field values that are empty or missing, which is referred to as NULL.  This occurs during the creation of a record in a given table, when the field is not required to have a value.  This differs from zero values or spaces, and cannot be … Read more