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
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
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.
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 !??
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!
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.
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,
