Scenario based Question in Talend???

[Prasanna3]

I have two CSV files.
one file contains address column
second file no address column.
How can I read schema dynamically and store it in db.

[iamabhishek]

Sample data with schema details and expected output would help to provide a solution.
Dynamic schema is supported in subscription version of Talend. Link - https://help.talend.com/reader/XYG1yAFeBFz4I4dovmWbsQ/TkXCN1rKY8XzcyFzl72s9A

[Prasanna3]

File1:

empno,ename,Dept,sal,sum

File2:

empno,ename,sal,sum

Above two CSV files data .
I have to load two files data into one single table.
while loading if Dept column contains Dept I should load other I should not load.

[iamabhishek]

This could be easily done via tMap. Select "Left Outer Join" as your join model & you could set your match key on empno ( guessing this to be primary key sort of).
And for your output just have a output table created and then select all the relevant columns from the two files (left side) to the right side for your output table.

[Prasanna3]

My question is.

Some dynamic columns are coming in sometimes.that time how read CSV file and how to do mapping in tmap

[Ganshyam]

Hello,

Refer to below link , if it solves your purpose.

https://community.talend.com/t5/Design-and-Development/tMap-with-Dynamic-schema/td-p/43409

Regards

Ganshyam