Talend Connect
Virtual Summit
JOIN US!
And visit the Customer
& Community Lounge.
May 27-28, wherever you are.

add custom message for rejected data

Highlighted
Eight Stars

add custom message for rejected data

hello,

i have 2 rejected excel files that are having rejected phone numbers. rejected email id,  so want want to join this tables and create one custom message column that shown on phone number data "number missing error" on email message  "@",dot is missing. ??  


Accepted Solutions
Highlighted
Community Manager

Re: add custom message for rejected data

You need to use a tUnite component. Your two sources need to be read into tMap components (different ones). The tMap will change the schema to a unified one. You then connect to a tUnite and your output will be mixed. 

 

1) Telephone source ----> tMap1
Add an Error_Reason column and add "Wrong number" or whatever is your reason. 
2) Email source ----. tMap2
Add an Error_reason column and add "Incorrect Email Address" or whatever is your reason.

 

Both tMap1 and tMap2 MUST have the same output schema. You will need to ensure this.

 

3) tMap1 ----|
                    tUnite ----> the rest of the job
tMap2--------|

 

The tUnite will merge the rows and you will get the data in the format you want. This can be loaded to whichever target you want.

 

 

View solution in original post


All Replies
Highlighted
Nine Stars

Re: add custom message for rejected data

Please provide more details on you requirement. Sample data will help more to understand you requirement.

 

Regards,

Veeru Boppudi
Highlighted
Community Manager

Re: add custom message for rejected data

That's great.....but what do you need to know?

Highlighted
Eight Stars

Re: add custom message for rejected data

 
Highlighted
Eight Stars

Re: add custom message for rejected data

thanks for reply!!
rejected phone and rejected emailid table in one table with the one new column "error reason".
on
emailreject:- records it shows message "@,Dot missing" message
phonerejectrecords :- it shows "number missing " message
Highlighted
Eight Stars

Re: add custom message for rejected data


i have 2 excel records one is rejectedphone table and second is rejectedemailid table i want it in one table with the one new column "error reason".
on
emailreject:- records it shows message "@,Dot missing" message
phonerejectrecords :- it shows "number missing " message
Highlighted
Nine Stars

Re: add custom message for rejected data

Hi,

 

Are you looking for the following output?

 

rejectData.PNG

If yes, you can do it using tMap.

 

Regards,

Veeru Boppudi
Highlighted
Eight Stars

Re: add custom message for rejected data

yes exctly, but can u please tell me what expressions or any i use to get this type of output??
Highlighted
Community Manager

Re: add custom message for rejected data

You need to use a tUnite component. Your two sources need to be read into tMap components (different ones). The tMap will change the schema to a unified one. You then connect to a tUnite and your output will be mixed. 

 

1) Telephone source ----> tMap1
Add an Error_Reason column and add "Wrong number" or whatever is your reason. 
2) Email source ----. tMap2
Add an Error_reason column and add "Incorrect Email Address" or whatever is your reason.

 

Both tMap1 and tMap2 MUST have the same output schema. You will need to ensure this.

 

3) tMap1 ----|
                    tUnite ----> the rest of the job
tMap2--------|

 

The tUnite will merge the rows and you will get the data in the format you want. This can be loaded to whichever target you want.

 

 

View solution in original post

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

Best Practices for Using Context Variables with Talend – Part 2

Part 2 of a series on Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog