[resolved] Generic Talend Job

[Anonymous]

I want create a generic talend job with File Component , Tmap and Target Db Component.I have multiple files to load in multiple target tables with one talend job.But the metadata for each source and target are different.Let me know.

[Anonymous]

Hello K,

Did you got the confirmation on the dynamic schema if it is string ?

I have a requirement where i need to filter the records but i am not able to use any in tmap ( tried with contains) and it dosen't return anything at all

[Anonymous]

Requirement:

1> get the list of files

2>iterate through the files and see given Account_nun's are present

3>Remove the those accounts from the file and save the new files with removed accounts.

I am able to do all and missing out only in filter.

i am not able to use the contain and it simply returns me nothing. (account number cab be anywhere in the files)

I have used below and tried with % and * both.

 row10.newColumn.contains("BATCH-924")

where newColumn is dynamic schema type.

So the main question would be ( this is for the GD-PR requirement where we need to delete old customers):

1> can i use filter or search with dynamic schema 

2> if Yes how can i use the in such a way to remove the complete record when match exists

[badri-nair]

HI,

I am looking for a solution where the metadata for a file can be passed as an argument ? This Dynamic schema can only be used if there are few extra columns that needs to be added dynamically. In my case, metadata completely changes from one input file to other .

Kindly suggest a solution.

Thanks

Badri Nair 

---

@shong wrote:

Hi
With community version, you have to create many subjobs for each file. With commercial subscription version, you are able to define a dynamic schema to map different structure, so that you only need one general Talend job for all files. For more information, please read this page:
https://help.talend.com/search/all?query=dynamic+schema+

Regards
Shong

---