Transform Query to Inkremental Refresh

[joshua1990]

Hello everyone!

I would like to provide an incremental refresh for one of our biggest tables.

It is a oracle/ odbc table that is currently accessed by this sql:

SELECT F5801.AA1                  AS "Date", 
       F5801.AA11                 AS "Order", 
       CASE 
              WHEN F5801.AA12 ='1B' THEN Replace(REGEXP_SUBSTR(F5801.AA12 , '(^|[:])[0-9]+'), '+', '') 
       END AS "Value"

FROM   PROD.F5801 F5801
WHERE  F5801.AA1 > 120000 
       AND NOT EXISTS (SELECT * 
                       FROM   PROD.F5801 F5801_2 
                       WHERE  F5801_2.AA13 = F5801.AA14) 

As you can see, there is a Case within Select, a Date filter based on a Number, and the last filter based on Values within two columns.

Is it possible to get this transformed for an incremental refresh?

1. Filter Date in Number format
2. Case for String
3. Filter/ Join for two columns

[ibarrau]

Hi. I don't think you can handle this in a query. Incremental refresh is managed in power query. You can check this video to understand how to try it:

https://www.youtube.com/watch?v=BQahH53ayKU

Hope that helps 🙂