topic Re: Split one table into several tables by value in Talend Studio

Split one table into several tables by value

sactl — Tue, 30 Apr 2019 09:25:41 GMT

Hello to all,

I want to build several tables dynamically out of one big source table by one field value.

The source is like this:

YEAR MONTH col3 col4 ...... (a lot of colums)

2016 4 123 abc

2017 7 321 cba

....

now I want all rows from year 2016 in a new table named like 'source_2016' and another new table 'source_2017' with all the rows where year = 2017 and so on.

Is there a way to realize this so it will work automatically also if any new years will be added?

Thank you in advance

Re: Split one table into several tables by value

akumar2301 — Tue, 30 Apr 2019 09:53:14 GMT

try this

http://talendhowto.com/2017/10/27/how-to-split-file-depending-on-column-values-2/

it is for files but same should work for logic should work for Tables.

Re: Split one table into several tables by value

sactl — Tue, 30 Apr 2019 13:42:58 GMT

Thank you very much. I adapted that and it works perfectly.

However, is there a way to fill in the value fields in tfixedflowinput automatically with the globalMap values because in my case there are about 100 columns to fill? I could not find a way to simply take over all the input fields to output value

Kind regards