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.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Pick up some tips and tricks with Context Variables
Learn how media organizations have achieved success with Data Integration
Create systems and workflow to manage clean data ingestion and data transformation.