Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Advanced Incremental Load

Hi,   I take some data from Redshift through some Python scripts. I have set my scripts and I get 9 tables. Then I merge them into a new table that I call "Current Snapshot". The data refer to how...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    7 years ago

    Hi Anonymous

    Per your scenario, 

    then open the Edit Queries, copy table to get a new table (table1->table2)

    Right-click on the Table1, uncheck the "Include in the report refresh",

     

    close&&apply, create a new table by entering the formula

    Table = UNION(Table1,Table2)


    Thus, when you refresh from the data source, Table1 keep the original data, Table2 refresh with the new data, then the new table with a "union" function union the original data and new data.

     

    Best Regards

    Maggie

     

v-juanli-msft's avatar
v-juanli-msft
Community Support
7 years ago

Hi Anonymous

Per your scenario, 

then open the Edit Queries, copy table to get a new table (table1->table2)

Right-click on the Table1, uncheck the "Include in the report refresh",

 

close&&apply, create a new table by entering the formula

Table = UNION(Table1,Table2)


Thus, when you refresh from the data source, Table1 keep the original data, Table2 refresh with the new data, then the new table with a "union" function union the original data and new data.

 

Best Regards

Maggie