[resolved] Adding new rows to the data flow

[Anonymous]

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?

[Anonymous]

You should use a tFixedFlowInput

Best regards,

Alfonso Borre Sarmiento
skype: alfonso.borre

[Anonymous]

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

[Franz3]

Simplest way is to use a Tmap

[Anonymous]

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

[Franz3]

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?

[Anonymous]

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!

[Franz3]

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

[Anonymous]

It works with tUnite, look here:

[Franz3]

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.