5 Replies Latest reply on Feb 22, 2018 5:42 AM by Zhouyi Zhang

    Complex query needed

    Aniruddha Dhamne

      I have data as below. I want to create a calculated field which will give Store Name associated with the Retailer = "CS" for the same serial number across all rows.

      Below is an example..


      Original Data -

      Serial no      Retailer      Store Name

      123                WH           Warehouse

      123                CS                xyz

      123                AC                ABC


      Required Data -

      Serial no      Retailer      Store Name      New Field

      123                WH           Warehouse           xyz

      123                CS                xyz                    xyz

      123                AC                ABC                  xyz


      Please help!!!