Creating Dynamic Pivot Table using SQL

 In this post, I want to share SQL tips on how to create dynamic pivot table in SQL.The columns in the pivot table is not fixed in this case. Hence, there is a need to use dynamic SQL to achieve this.In this example, we will be forming a pivot table containing spending...

Read More

Activate Tableau Server Offline

If you are doing Tableau server license activation offline, it may be a bit problematic, and confusing.There is already an article published by Tableau showing how to do Tableau server license activation offline. However, the last part about how to process the activation.tlf is not mentioned.Hence, I am creating some guide on how to do that.After you...

Read More

Using Macro in Notepad++

 Sometimes, you need to bulk-edit text with the same patterns. However, you can't simply use text editor to find and replace the content. In this case, you can try using macro in Notepad++ to achieve that.This is a simple video on how you can do that using Notepad...

Read More