1 Reply Latest reply on Feb 10, 2019 11:43 AM by Shinichiro Murakami

    Need to View/Display matched and unmatched data

    Richie Berlin

      Hello Everyone!

       

      Kindly help me get this done.


      Scenario

       

      I'm having 3 data source (3 Excel sheets)

      S1,S2,S3

      Please note S1 and S3 are split into two sheets based on Domain

       

      S1 Domain - AA, BB, DD, EE
      S3 Domain - CC      

       

      I want to publish All the matched and unmatched data from all 3 datasource.


      Data source columns

      S1
      CR#1(String)
      Release Date

      Product name

      Lead

      Domain(AA,BB,DD,EE)

      S2
      CR2 Number(String)
      Checkpoint

      S3 (Here CR#3 and Cr no 3) are the same but split into 2 different format, if no match found with CR#3 then need to look for match with CRno3 in S2(Datasource)
      CR#3(String)
      CR no 3(Integer)
      CC(Part of Domain from S1)
      Lead

       

      I want to reference S1 and S3 to match S2 records and populate the matched and unmatched records from all 3 data sources.


      Also is there a possibility to bring S3's CC into Domain? like -
      Domain
      AA
      BB
      CC
      DD
      EE

      PFA Data Source FYR.

       

       

      Desired Output :-

        

      CR#1Release dateProduct nameLeadDomainCCCheckpoint
      CR101-02-2019soapRicAAComplete
      Cr220-02-2019dishVicBB
      CR302-21-2019foodmicDDComplete
      CR422-02-2019spraypersEEIncomplete
      CR523-02-2019carmikFFComplete
      CR624-02-2019bikedavGGIncomplete
      CR7RicCCComplete
      CR8VicCCIncomplete
      CR9micCCComplete
      CR10persCCIncomplete
      CR11mikCCComplete
      CR12micIncomplete
      CR13persCC
      CR14Incomplete
      CR15Incomplete

      PFA Data Sources

       

      Sorry for spamming this question, but my deadline date is very close, I need to finish this asap.
      Would really appreciate your help.