topic [resolved] Adding new rows to the data flow in Talend Studio

[resolved] Adding new rows to the data flow

Anonymous — Fri, 17 Jun 2016 16:38:53 GMT

I have a job that generates an output like this:

Name;Points
a;1
b;2
c;3

How can i add new fixed rows like d;4 e;5 etc. to the data flow?

Re: [resolved] Adding new rows to the data flow

Anonymous — Fri, 17 Jun 2016 22:55:47 GMT

You should use a tFixedFlowInput

Best regards,

Alfonso Borre Sarmiento
skype: alfonso.borre

Re: [resolved] Adding new rows to the data flow

Anonymous — Mon, 20 Jun 2016 09:08:08 GMT

How can i connect tFixedFlowInput with tFileInputDelimited to add the fixed rows to the data flow?

Re: [resolved] Adding new rows to the data flow

Franz3 — Tue, 21 Jun 2016 14:11:33 GMT

Simplest way is to use a Tmap

Re: [resolved] Adding new rows to the data flow

Anonymous — Wed, 22 Jun 2016 14:25:12 GMT

Fwandz wrote:
Simplest way is to use a Tmap

I had no success with tMap, but tUnite did the job for me.

Just curious: How do i setup tMap for connecting two tables like these?

Input Table1:
a;1
b;2
c;3

Input Table2:
d;4
e;5
f;6

Output Table:
a;1
b;2
c;3
d;4
e;5
f;6

Re: [resolved] Adding new rows to the data flow

Franz3 — Wed, 22 Jun 2016 14:54:12 GMT

I don't understand what you want to do. You don't have any foreign key in your tables?
How can you know that a,b,c goes with the right d,e,f?

Re: [resolved] Adding new rows to the data flow

Anonymous — Wed, 22 Jun 2016 16:19:53 GMT

Both tables are independant from each other, i just want to append the rows of table2 to the rows of table1.
tUnite seems to be the right choice here.
Thank you anyway!

Re: [resolved] Adding new rows to the data flow

Franz3 — Thu, 23 Jun 2016 09:02:55 GMT

Tunite?
Tunite only merge, that means you need to have the same schema in input.
It won't mix your lane together :

Input Table1:
a;1
b;2
c;3
Input Table2:
d;4
e;5
f;6
Output Table:
a;1
b;2
c;3
d;null
e;null
f;null
plus
a;null
b;null
c;null
d;4
e;5
f;6

Re: [resolved] Adding new rows to the data flow

Anonymous — Thu, 23 Jun 2016 09:12:20 GMT

It works with tUnite, look here:

Re: [resolved] Adding new rows to the data flow

Franz3 — Thu, 23 Jun 2016 10:59:35 GMT

Wao sorry i have pretty much no idea of what you wanted.
Thought that was a different schema and you wanted to add the column.
My bad.