Six 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

 

 

7 REPLIES
Forteen Stars TRF
Forteen 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
Six 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.

Forteen Stars TRF
Forteen 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
Six 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)
Forteen Stars TRF
Forteen 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
Six 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)
Forteen Stars TRF
Forteen Stars

Re: multiple tables with exception message column

After the last tMap

TRF