Skip to main content
To homepage To homepage
Solved

Updating table values - history settings

  • March 20, 2023
  • 2 replies
  • 95 views
A
Contributor

I have loaded a table with some initial data  (== initial stoock). The key is quiet simple  Company, Warehouse and Item

Now I want to update the amounts every day so that it reflects the actual stock level of data day

The initial load was done from one source , the updates come from another sources 

History settings  have natural jkey set , and all non lookup fields are updsated  (type 1)

Nevertheless the record is not updated 

Any idea ‘why’ the update is not working

Best answer by alain.thire

Thanks

 

I got it working now. In fafct I have a feeder for historical data and an incremental insert for the updates.  I remloved the incremental insert , and things work. 

Not sure ‘why’ because the proposed settings were always used but it looks like working 

Thanks anyway

    2 replies

    Christian Hauggaard
    Community Manager
    Forum|alt.badge.img+5

    Hi @alain.thire 

    Can you please add some screenshots of the table and the history settings similar to below?

     

    A
    Contributor
    • alain.thire
    • Author
    • Contributor
    • 7 replies
    • Answer
    • March 20, 2023

    Thanks

     

    I got it working now. In fafct I have a feeder for historical data and an incremental insert for the updates.  I remloved the incremental insert , and things work. 

    Not sure ‘why’ because the proposed settings were always used but it looks like working 

    Thanks anyway


    Terms and ConditionsCookie settingsAccessibility statement