Kindly help me get this done.
I'm having 3 data source (3 Excel sheets)
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
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 no 3(Integer)
CC(Part of Domain from S1)
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 -
PFA Data Source FYR.
Desired Output :-
|CR#1||Release date||Product name||Lead||Domain||CC||Checkpoint|
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.