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

What’s New for Talend Spring ’19

Join us live for a sneak peek!

Sign up now

Definitive Guide to Data Quality

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

Download

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch

Downloads and Trials

Test drive Talend's enterprise products.

Downloads