Author: sab
-
By parsing JSON array, you get values in brackets and double quotas and might need to make the string more human readable. Regular expression REGEXP_REPLACE can be used for it in your sql. Input string: [“Blue”], [“Pink”], [“Black”] Output string: Blue; Pink; Black Action: Get rid of brackets with double quotas and replace comma by…
-
Find what: [ ]+’ Replace with: ‘ Search Mode: Regular expression It means: Replace all repeating space characters adjacent to single quote by single quote. [ ]+ =collect spaces [ ]+’ =collect spaces adjacent to single quote Similarly you can use ‘[ ]+ to collect spaces following single quote.
-
If we want to combine data about same information from two sources, we can think of using two sql approaches: Full Outer Join shows better performance statistics in all 3 aspects: CPU, IO and Spool. Let’s say we have orders with customer info from two different data sources. Both are relevant data sets, some orders are only…
-
Un-pivot aka transpose from columns to rows using SQL or UNPIVOT Teradata function. Data preparation: Solution using SQL Solution using Teradata UNPIVOT function
-
Transpose from rows into columns by using sql or pivot database function. Data preparation: Solution using SQL Solution using Teradata PIVOT function
-
Solution using regexp split to table Solution usineg SQL WITH RECURSIVE
-
Welcome to WordPress. This is your first post. Edit or delete it, then start writing!