multiple tables with exception message column

Seven Stars

multiple tables with exception message column

Hello,

I want to create this scenario where i have to store table name which are having invalids record i.e. having reference to nothing

I want to store such table name in target table. 

is there any specific component or any method ??

image.png

 

 

Fifteen Stars TRF
Fifteen Stars

Re: multiple tables with exception message column

Not very clear as it seems your example is not exact: records matching with nothing are 3 and 5 instead as 4 and 5.

However, having a tMap with 2 lookups (for file2 and file3) should be enough.


TRF
Seven Stars

Re: multiple tables with exception message column

Thanks @TRF for reply,

i want to print table name in error column where 

values of acct_id in file1 does not belong to file2

values of trans_type_cd  in file1 does not belong to file3.

Fifteen Stars TRF
Fifteen Stars

Re: multiple tables with exception message column

In this case you have to proceed in several steps:

  1. join file1 with file2 in 1 tMap and add "file2" to the output 1
  2. join file1 with file3 in an other tMap and add "file2" to the output 2
  3. join output 1 & 2 with a left outer join to retrieve rows not in file2 and/or file3

 


TRF
Seven Stars

Re: multiple tables with exception message column

thanks you so much  @TRF it works..

but i want input filename in output column which are having errors, see screenshot . so what is the next step?image.png

 

 

 

Tags (1)
Fifteen Stars TRF
Fifteen Stars

Re: multiple tables with exception message column

You need to use tAggregate group by "Id" and operation List for field "file".

Here is a capture of the component settings:

Capture.png

 

and the result:

Démarrage du job test a 10:20 30/05/2018.
[statistics] connecting to socket on port 3687
[statistics] connected
.--+-----------.
|  tLogRow_50  |
|=-+----------=|
|id|file       |
|=-+----------=|
|1 |file1,file2|
|2 |file1      |
|3 |file1,file2|
'--+-----------'
[statistics] disconnected
Job test terminé à 10:20 30/05/2018. [Code sortie=0]

TRF
Seven Stars

Re: multiple tables with exception message column

Thanks @TRF sir, can u plz tell me in which place i can put tAggregate component to get filename in output table , this is my job snap.image.png

 

 

 

Tags (1)
Fifteen Stars TRF
Fifteen Stars

Re: multiple tables with exception message column

After the last tMap

TRF

2019 GARNER 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

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download