Skip to main content
To homepage To homepage
Solved

Updating table values - history settings

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

View original
    Did this topic help you find an answer to your question?

    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

    Christian Hauggaard
    1 person likes this
    • Christian Hauggaard
      Christian Hauggaard

    Reply


    Most helpful members this week

    Terms and ConditionsCookie settings

    Cookie policy

    We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

     
    Cookie settings