topic Re: Scenario based Question in Talend??? in Talend Studio

Scenario based Question in Talend???

Prasanna3 — Sat, 16 Nov 2024 07:28:36 GMT

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.

Re: Scenario based Question in Talend???

iamabhishek — Fri, 12 Oct 2018 11:41:32 GMT

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

Re: Scenario based Question in Talend???

Prasanna3 — Fri, 12 Oct 2018 11:49:33 GMT

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.

Re: Scenario based Question in Talend???

iamabhishek — Fri, 12 Oct 2018 11:58:31 GMT

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.

Re: Scenario based Question in Talend???

Prasanna3 — Fri, 12 Oct 2018 12:03:23 GMT

My question is.

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

Re: Scenario based Question in Talend???

Ganshyam — Fri, 12 Oct 2018 12:54:23 GMT

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