multiple tables with exception message column

[Anonymous]

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

[TRF]

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.

[Anonymous]

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.

[TRF]

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

[Anonymous]

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?

[TRF]

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]

[Anonymous]

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.

[TRF]

After the last tMap