With the unveiling of Fivetran Transformations, you now have even more reason to perform arithmetic operations across columns within your data warehouse. Unfortunately, a case may arise where a value is missing, but its absence should not invalidate an entire record.
Suppose you have sales records from a variety of jurisdictions and product categories. Not all jurisdictions have sales taxes and some product categories come with mandatory hazardous materials fees:
| item | price | tax | hazmat_fee |
|---|---|---|---|
| oat_bran | 1.00 | 0.06 | NULL |
| scalpel | 5.50 | NULL | NULL |
| mercury_fulminate | 200.00 | NULL | 35.00 |
| cesium_iodide | 450.00 | 45.00 | 35.00 |
If you tried to calculate the total cost for each record using the following query:
Your results will look like so:
A friendly reminder: One plus NULL equals NULL
A friendly reminder: One plus NULL equals NULL
With the unveiling of Fivetran Transformations, you now have even more reason to perform arithmetic operations across columns within your data warehouse. Unfortunately, a case may arise where a value is missing, but its absence should not invalidate an entire record.
Suppose you have sales records from a variety of jurisdictions and product categories. Not all jurisdictions have sales taxes and some product categories come with mandatory hazardous materials fees:
Verwandte Beiträge
Kostenlos starten
Schließen auch Sie sich den Tausenden von Unternehmen an, die ihre Daten mithilfe von Fivetran zentralisieren und transformieren.
