Is there a component that allows to generate fixed rows?

One Star

Is there a component that allows to generate fixed rows?

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

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

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
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

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

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

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

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
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

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

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.
Six Stars

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

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

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

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 !??
Six Stars

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

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!
One Star

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

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.
One Star

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

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,