Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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. ??
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.
Please provide more details on you requirement. Sample data will help more to understand you requirement.
Regards,
That's great.....but what do you need to know?
Hi,
Are you looking for the following output?
If yes, you can do it using tMap.
Regards,
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.