Loading

Creating an Incremental Refresh with Multiple Unique SQL Tables

Publiseringsdato: Apr 13, 2024
Oppgave
How to combine multiple unique SQL tables, when creating or refreshing an incremental extract in Tableau Desktop.
Trinn

Option 1 

Create and refresh separate extracts (per table) and use data blending in the workbook. This option will allow each of the extracts to be refreshed incrementally independent of the others and it does not require any changes on the database side to implement. When used together in a workbook, the tables can be blended on date fields or some other non-unique field that they have in common. Additionally, each data sources can be published and used independently.

Option 2 

Work with your database administrator or your SQL Server administrator to create a a view in SQL Server that combines the multiple tables and provides its own unique key. This view would just be connected like any other table and an incremental extract can be made on the key of the view instead of those in the original tables.
Knowledge-artikkelnummer

001456657

 
Laster
Salesforce Help | Article