topic multiple tables with exception message column in Talend Studio

multiple tables with exception message column

Anonymous — Mon, 28 May 2018 15:19:57 GMT

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

Re: multiple tables with exception message column

TRF — Mon, 28 May 2018 15:28:37 GMT

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.

Re: multiple tables with exception message column

Anonymous — Mon, 28 May 2018 15:58:28 GMT

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.

Re: multiple tables with exception message column

TRF — Mon, 28 May 2018 17:24:01 GMT

In this case you have to proceed in several steps:

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

Re: multiple tables with exception message column

Anonymous — Tue, 29 May 2018 15:51:40 GMT

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?

Re: multiple tables with exception message column

TRF — Wed, 30 May 2018 09:20:37 GMT

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

Here is a capture of the component settings:

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]

Re: multiple tables with exception message column

Anonymous — Wed, 30 May 2018 09:33:16 GMT

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.

Re: multiple tables with exception message column

TRF — Wed, 30 May 2018 10:04:04 GMT

After the last tMap