1 Reply Latest reply on Aug 1, 2018 12:58 PM by Patrick A Van Der Hyde

    Replicate the matched data with Null Data

    Ganesh Vijay Kumar

      Hello Experts,

       

      I am trying to create a calculation and stuck in between. Hope any one could guide me to arrive at the desired results.

       

      Below are list of data source I am using:

       

      1) Primary Data Source: Below is the screen shot for your reference.

       

      Primary Datasource.PNG

       

      Under Requested week 201826: Snapshot week 201822 and 201823 are missing.

      Under Requested week 201825: Snapshot week 201822 is missing.

       

      Since I am doing all the calculations at row level. I cannot afford to have missing data. Hence I create an additional data source for all the missing weeks and did a cross data base join.

       

      2) Missing weeks Data source : Below is the screen shot for your reference.

       

      Missing Weeks.png

       

      Post joining the data I have all the missing columns in the data.

       

      To identify the part type I blend my primary data source to another data source named Part Type Details.

       

       

      3) Part Type Details:

       

      Part Type Details.PNG

       

      Everything goes well. But I see NULL for the missing weeks and I hit a roadblock to get the desired results.

       

      Final Data.png

       

      As I mentioned earlier I am doing a row level calculation using Table Calculations. Is there any function we could write to Show MTS even in Missing weeks, I have just highlighted week 201822 and 201823 for your reference.

       

      In any of the snapshot weeks if we have MTS could we replicate the same where we have NULL. All I need is MTS in the entire "Part type" column.

       

      I have attached the TWBX file for your reference. And help solving this will be greatly appreciated.

       

      Thanks,

      Ganesh