From Date-To Date from QVD

[#1]

Hello Team,

I have a QVD which has product details. The fields are product id, product name, price, update date.

Now a product price and product name can change for a product id. I want to maintain versions and later on using interval match I would like to see what was the price/name during that interval. The update data monitors the day of change.

Can someone explain how to put a from date and to date field to capture the change using a QVD.

Please have a look at the attached excel for the data. The product id 123 and 234 has both price change and name change.

Thanks,

[Gysbert_Wassenaar]

So if I understand you correctly you have only one date field named update date and you want to create a from date and to date fields from that. If that's right then read this blog post: Creating a Date Interval from a Single Date‌. You might want to read this document too: IntervalMatch and Slowly Changing Dimensions