add custom message for rejected data

[Anonymous]

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. ??  

[vboppudi]

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

Regards,

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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

[vboppudi]

Hi,

Are you looking for the following output?

If yes, you can do it using tMap.

Regards,

[Anonymous]

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

[Anonymous · Accepted solution]

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.