Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
2 years ago

Data Update Error (Adds the data many times)

Hi everyone, I need to raise the following topic, as I have not been able to find the solution to my problem. I tell them to develop a financial model, which considers the budget for the year. The c...
Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
2 years ago

RangeStart

RangeEnd

From the editor

I have the following query, the date range with incremental load is at the end of the query, by this I mean I have queries appended after the RangeStart and Range End condition.

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

Your parameters look good. Now show the query where you use them.

  • Syndicate_Admin's avatar
    Syndicate_Admin
    Icon for Administrator rankAdministrator
    2 years ago

    Exieten queries based on SQL connection and excel file

    Both consultations were consolidated and annexed in a sheet called consolidated

    Now the report in the web service throws me

    January, it adds two months to the values, February gives it to me correctly and from March to December it doesn't give me values.

    In summary, the information in ppto 24 is only read for the months of January and February (January adds the values twice and February correctly)

    Filter from March to December

    • lbendlin's avatar
      lbendlin
      Icon for Super User rankSuper User
      2 years ago

      Your filter is wrong. Only RangeStart should be inclusive. RangeEnd must be exclusive.

       

      each [RefDate] >= RangeStart and [RefDate] < RangeEnd

      • Syndicate_Admin's avatar
        Syndicate_Admin
        Icon for Administrator rankAdministrator
        2 years ago

        Change and review the filters, [RefDate] >= RangeStart and [RefDate] < RangeEnd

        And now the result is that January is right

        But from February onwards I don't get any information from PPTO 24

        Could it be related to the fact that I don't have data as real 2024?