Skip to Content

How do I split monthly price validity in to weekly in HCI DS

Feb 07 at 05:38 AM


avatar image
Former Member

Hi All,

Let say I have a below requirement.

material validitystartdate validityenddate price

Matr1 07-Feb-2018 08-Aug-2018 100

In above case one line of material with validity 6 months and price is 100. I want to split this record into weekly(6*4=24 weeks/lines of records with same price.

How can i achieve this in HCI DS?

Apprecate you help

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

avatar image
Former Member Mar 06 at 05:05 PM

Hi Praveen,

use row generation to create your weekly buckets for the entire time horizon and then join the source file with row_gendate > valid_fromdate and row_gendate < valid to date.

then you should get that 100 across all buckets.


10 |10000 characters needed characters left characters exceeded