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 ??
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.
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.
In this case you have to proceed in several steps:
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?
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]
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.
Join us live for a sneak peek!
Create systems and workflow to manage clean data ingestion and data transformation.
Introduction to Talend Open Studio for Data Integration.
Test drive Talend's enterprise products.