topic Re: Is there a component that allows to generate fixed rows? in Talend Studio

Is there a component that allows to generate fixed rows?

Anonymous — Sat, 16 Nov 2024 13:50:11 GMT

I know there is a tFixedFlowInput and a tRowGenerator components but what I want is simply a kind of fixed table?

Re: Is there a component that allows to generate fixed rows?

Anonymous — Mon, 10 Aug 2009 03:26:32 GMT

Hello
tFixedFlowInput generate some rows with fixed value.
tRowGenerator can generate some rows with range of set value, eg: if you set function as: "..." and set the value of parameter as "shong", "elise", it will generate rows "shong" or "elise".
Best regards
shong

Re: Is there a component that allows to generate fixed rows?

Anonymous — Wed, 12 Aug 2009 13:26:28 GMT

tRowGenerator doesnt work for me because it generates rows randomly.
How do I specify a bunch of fixed rows using the tFixedInputFlow?

Re: Is there a component that allows to generate fixed rows?

Anonymous — Thu, 13 Aug 2009 04:33:52 GMT

Hello

How do I specify a bunch of fixed rows using the tFixedInputFlow?

bunch?? What do you mean?
Add columns on schema, then set value for each column, eg:
1 for int type
"shong" for string type
TalendDate.getCurrentDate() for Date type
Best regards
shong

Re: Is there a component that allows to generate fixed rows?

Anonymous — Fri, 14 Aug 2009 15:22:08 GMT

Yes that's good if I need just one row, but what if I need many?. Ah! And I mean not loading from a file, I mean a component must let me specify those rows directly on the properties view. I think writting sql inserts or creating a delimited file just for adding a few preknown rows have no fun.

Re: Is there a component that allows to generate fixed rows?

Anonymous — Fri, 14 Aug 2009 17:42:37 GMT

with tfixedinputflow you can specify more than one row, look at the properties...

Re: Is there a component that allows to generate fixed rows?

_AnonymousUser — Sat, 15 Aug 2009 16:00:43 GMT

You can generate many rows, thats the joke with this component, it only repeat the same row. I dont undertand how a basic component like this doesnt exist, I mean, I must die writing inserts for tables like XXXXXX_TYPE !??

Re: Is there a component that allows to generate fixed rows?

Anonymous — Sun, 16 Aug 2009 10:44:57 GMT

You are basically in need to have a little readonly input table directly specified in a component GUI and job definition (not defined externally)...
Yes, I agree would be nice to have such component ( a sort of tTalendInputTable editable by GUI, useful for testing and simple hardwired lookup tables defined in the job ).
Please post a feature request in the bug tracker!

Re: Is there a component that allows to generate fixed rows?

Anonymous — Tue, 25 Aug 2009 20:57:42 GMT

see bugtrackers 0004750, 0008783 and forum 5303. The tFixedFlowInput component was developed by plegall and he say that he wanted to do that for this component but the limitation by the time was with the TABLE "BASED_ON_SCHEMA" property of the component descriptor that doesnt let you define more than one row on a table. I`ll develope this component I swear, I´m learning how to build one I hope to have luck.

Re: Is there a component that allows to generate fixed rows?

_AnonymousUser — Mon, 01 Mar 2010 15:36:56 GMT

I managed that with the following component :
tForeach -> tIteraToFlow -> textractRegexFields

On tForeach :
I put row 1 : "value1_of_col1,value2_of_col2"
row2 : "value3_of_col1, value4_of_col2"
...
On tExtractRegexFields:
Regexpression : "^(.*),(.*)"
Colomun name of the shema
See u,