Skip to Content
avatar image
Former Member

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

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.

    Thanks!!

    Add comment
    10|10000 characters needed characters exceeded