Author: Glocer Wang

Qlik Sense - 6 0

Qlik Sense – note 2

NoConcatenate Keyword Add NoConcatenate before LOAD to prevent new table being added in the same table.  Add MS Access Driver in Windows 7 Sometimes, you need to add MS Access Driver in the System...

Qlik Sense Data Model 0

Qlik Sense – note 1

Data Model The Data Model in Qlik Sense is very much similar to traditional data model in DW practice.  It is recommended to use Star or Snowflake schema. In either case, getting Data Model...

SQL-2 0

T-SQL Wildcard

T-SQL provides a LIKE predicate. When using it, we often use some Wildcard signs in our query. The % Wildcard The percent sign represents any string, including empty ones. The _ Wildcard The underscore...

SQL-0 0

COALESCE and CONCAT

COALESCE Function The Coalesce function takes a list of input values and returns the first that is not NULL. For Example, SELECT A, B, C, D, B + COALESCE( N ‘,’ + C, N”)...

DSC01904 0

Making Japanese Miso

I had this post for years in my previous website. now I decided to add it back. I hope it will provide some tips for people who want to make their own miso. Step...

SQL-1 0

T-SQL Joins

I just had a idea to posted some T-SQL tips online, as I don’t want to flip my note book again and again looking for answers. Inner Joins It applies a product between two...