Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Append incremental query with regular query

Hi!   I have two queries, one which has incremental refresh (query A). And one that's refreshing normally (query B). I then append these queries into a new one (query C). So when I publish the re...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi lbendlin,

    Thanks, but I know that the RangeStart and RangeEnd parameters are just placeholders.

     

    I think I've solved my issue! I had to setup incremental refresh on the appended table as well. So for the rows coming from the Query B (which I want to fully update everytime the report refreshes) I had to add a fake DateTime column (with the same name used in Query A for filtering with RangeStart and RangeEnd) and set it's value to todays date. When I then append them into Query C I filter that appended DateTime-column again there on RangeStart and RangeEnd.

lbendlin's avatar
lbendlin
Super User
5 years ago

It may depend on when in the ETL process you introduce the range filter. Normally you would want to do that at the very beginning of the query for Table A,  and not (for example) at the end of Query C.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Yes, I get that. So now I do it at the beginning of Query A and then again in the appended Query C at the end. But I don't filter Query B with the range filters.

Seems to give me the result I want. Have to wait until tomorrow (CET) though to see if any new posts could be loaded.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Just wanted to let anyone who might be reading this know that the solution (described in the post marked as solution) worked.