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

[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

[former_member361253]

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.

Thanks!!