Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a problem to find/calculate the historic Stock Availability.
In the meantime i want to save/store the Stock Availability per day per product.
How do i do that?
I have:
Product Warehouse Stock Availability
So i need to extract the values everyday, give it todays date and store it inside the qvd?
Regards Sebastian
Hi Sebastian,
How much data you can extract in initial load , like for last year , I believe you may at least once extract some old data and then write a incremental script and add one column as "Today() as date" and saves it on daily basis if the use case is your data is available only for this day. or if you can extract data on week , month so it is also possible ,Its all about your use case , data availability and use case.
Hi,
There is no historical data, so i need to save down snapshots for everyday.
Roughly how do I write a incremental script to run everyday?