5 Replies Latest reply: May 30, 2013 1:15 AM by Karthikeyan S RSS

    Derived Data based on condition

    Raja Bpl

      Hi,

      Based on the below tables, I need to derive the third table called Required Data.
      Based on Priority & Model Code from Priority table, need to compare the Data table contents & derive the resultant Required Data table.

       

      Please refer the attached excel file for the reference.

       

       

       

      Priority:

      PriorityModel CodeModel Name
      4RZF50RAstar
      3LF50RBstar
      2TGN40RCstar
      1KUN40RDstar
      5OTHERSOTHERS

       

      Data:

      Applicable Model 1Applicable Model 2Applicable Model 3Applicable Model 4Applicable Model 5Applicable Model 6
      ACV30RGRJ120KUN40RKUN51RTGN40R
      ACV30RGRJ120LF50RNDE140ZRE142
      ACV30RGRJ120NDE140NGK15RNUK10R
      ACV30RGRJ120NDE140NUK10RNUK15R
      ACV30RGRJ120NDE140ZRE142ZVW30R
      KUN40RGRJ120NDE140ZRE142ZZE142
      ACV30RGRJ120NUK10RNUK15RZVW30R
      ACV30RGRJ120TGN40R
      ACV30RGRJ120TGN40RZRE142ZVW30R
      ACV30RGRJ120ZVW30R
      ACV30RKUN40R
      ACV30RKUN40R
      KUN40RTGN40R

       

      Required Data:

       

      Model NameApplicable Model 1Applicable Model 2Applicable Model 3Applicable Model 4Applicable Model 5Applicable Model 6
      DstarACV30RGRJ120KUN40RKUN51RTGN40R
      BstarACV30RGRJ120LF50RNDE140ZRE142
      OTHERSACV30RGRJ120NDE140NGK15RNUK10R
      OTHERSACV30RGRJ120NDE140NUK10RNUK15R
      OTHERSACV30RGRJ120NDE140ZRE142ZVW30R
      DstarKUN40RGRJ120NDE140ZRE142ZZE142
      OTHERSACV30RGRJ120NUK10RNUK15RZVW30R
      CstarACV30RGRJ120TGN40R
      CstarACV30RGRJ120TGN40RZRE142ZVW30R
      OTHERSACV30RGRJ120ZVW30R
      DstarACV30RKUN40R
      DstarACV30RKUN40R
      DstarKUN40RTGN40R