Help Required
Richie Berlin Feb 10, 2019 10:22 AMHello 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.
Output should be
CR#1 | Release date | Product name | Lead | Domain | CC | Checkpoint |
CR1 | 01-02-2019 | soap | Ric | AA | Complete | |
Cr2 | 20-02-2019 | dish | Vic | BB | ||
CR3 | 02-21-2019 | food | mic | DD | Complete | |
CR4 | 22-02-2019 | spray | pers | EE | Incomplete | |
CR5 | 23-02-2019 | car | mik | FF | Complete | |
CR6 | 24-02-2019 | bike | dav | GG | Incomplete | |
CR7 | Ric | CC | Complete | |||
CR8 | Vic | CC | Incomplete | |||
CR9 | mic | CC | Complete | |||
CR10 | pers | CC | Incomplete | |||
CR11 | mik | CC | Complete | |||
CR12 | mic | Incomplete | ||||
CR13 | pers | CC | ||||
CR14 | Incomplete | |||||
CR15 | Incomplete |
Message was edited by: Richie Berlin I have edited the datasource as per the scenario, please help me with this one
-
Output.xlsx 9.4 KB
-
S3.xlsx 9.5 KB
-
S2.xlsx 10.7 KB
-
S1.xlsx 9.3 KB