1 2 Previous Next 18 Replies Latest reply on Feb 13, 2019 4:02 AM by Richie Berlin

Help Required

Richie Berlin Feb 10, 2019 10:22 AM

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.

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

1. Re: Help Required

Vaishnavi krishnan Feb 9, 2019 1:51 AM (in response to Richie Berlin)
Hi Richie
I used blending here and got following output, i hope this will help you

3 data Source.twbx 43.8 KB
Like Show 0 Likes(0)

Actions
2. Re: Help Required

Richie Berlin Feb 9, 2019 5:04 AM (in response to Vaishnavi krishnan)

Thanks @Vaishnavi krishnan
Let me check this now and is there any possiblility to get CC under domain?
Like Show 0 Likes(0)

Actions
3. Re: Help Required

Zhouyi Zhang Feb 9, 2019 5:07 AM (in response to Richie Berlin)
Hi, Richie

Not quite sure what's your expected output? Is it something as below? if yes, please find attached workbook.

ZZ

Book1_v10.2.twbx 39.3 KB
Like Show 0 Likes(0)

Actions
4. Re: Help Required

Richie Berlin Feb 9, 2019 6:20 AM (in response to Richie Berlin)

Thank you for your responses guys! really appreciate it, @Vaishnavi krishnan
your reply works like a charm.
I have missed certain detail to my datasource, updated is my currentdatasource query, please help me the same with this one.

Zhouyi Zhang, thanks for your reply mate, but unfortunately that is not what i was looking for, I provided wrong info datasource, updated one attached to this please help me out
Like Show 0 Likes(0)

Actions
5. Re: Help Required

Vaishnavi krishnan Feb 9, 2019 10:15 AM (in response to Richie Berlin)

This is with your updated Data source. Adding a row in domain , need to work on it .
Like Show 0 Likes(0)

Actions
6. Re: Help Required

Richie Berlin Feb 9, 2019 10:36 AM (in response to Vaishnavi krishnan)

Sorry to bother you, but value 138 is missing from ID# in this view.
I want to have both matched and unmatched columns displayed.
Like Show 0 Likes(0)

Actions
7. Re: Help Required

Richie Berlin Feb 9, 2019 10:39 AM (in response to Vaishnavi krishnan)

Thank you so much, but I need to display all the matched and unmatched records, certain unmatched CR# and ID# are missing in your "view" in your first comment.
Like Show 0 Likes(0)

Actions
8. Re: Help Required

Zhouyi Zhang Feb 10, 2019 4:33 AM (in response to Richie Berlin)

Hi, Richie

Can you tell what's your expected result based on the below data for S1,S2 and S3?

ZZ
Like Show 0 Likes(0)

Actions

9. Re: Help Required

Richie Berlin Feb 10, 2019 7:23 AM (in response to Zhouyi Zhang)

Thank you for your response I have added my expected out result, sorry for spamming the same discussion multiple times, its very urgent requirement. My sincere apologies.

Expected output should be like this or if possible please bring the CC under Domain.

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

10. Re: Help Required

Richie Berlin Feb 10, 2019 7:36 AM (in response to Zhouyi Zhang)

Hi Zhouyi,

Actually S3 (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 Cr no 3 in S2(Datasource)
Like Show 0 Likes(0)

Actions
11. Re: Help Required

Richie Berlin Feb 10, 2019 7:38 AM (in response to Vaishnavi krishnan)

Vaishnavi, I have edited the datasource as per my requirement, sorry this would be the final version.

Using this forum for the first time.

My requirement is to get the matched records from S1 and S3 from S2 and display the matched and unmatched records.

Thanks
Like Show 0 Likes(0)

Actions
12. Re: Help Required

Richie Berlin Feb 10, 2019 7:39 AM (in response to Zhouyi Zhang)

I have edited the data source perfectly to my requirement, sorry for spamming aswell as asking this multiple times, this is the first time im using any forum, this is very helpful.

Kindly help me with this one
Like Show 0 Likes(0)

Actions
13. Re: Help Required

Shinichiro Murakami Feb 10, 2019 11:42 AM (in response to Richie Berlin)
not quite certain but something like this?

Save three files in same folder

Create wild car union.t

You need to figure out the logic to clean up this.

Thanks,
Shin

wcunion_v10.5.twbx 45.7 KB

1 of 1 people found this helpful
Like Show 1 Likes(1)

Actions
14. Re: Help Required

Richie Berlin Feb 10, 2019 7:17 PM (in response to Shinichiro Murakami)

Thank you so much, this is what I was expecting for, thanks so much again.

and one more thing, Is there a way to bring "CC" under "Domain"?
Like Show 0 Likes(0)

Actions