Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I want to put each row which i got from tsalesforceInput after querying .. into a separate excel sheet..
Please suggest how to achieve this...PFA..
@uganesh,i suggest you to use tMap between tsaleforceinput and tFileOutputExcle and generate the filenames in tMap using as a filed and then in the tFileOutputExcel using output stream option from the basic settings and specify the filed name based on that filed files will be generated.
As the whole data flow arriving into the tFileOutputExcel component will go to the same sheet, you need to use both tFlowToIterate and tIterateToFlow components between tSalesforceInput and tFileOutputExcel.
This suppose that the sheetname can be directly derived from the schema fields.
Else you will need a tMap or tJavaXxxx component to construct the desired sheetname.
Hi,
I have tried that way..but getting below error.
Error :
Error in the component's properties:Type mismatch: cannot convert from Object to String
Type mismatch: cannot convert from Object to String
Type mismatch: cannot convert from Object to Date
Type mismatch: cannot convert from Object to String
Type mismatch: cannot convert from Object to String
Type mismatch: cannot convert from Object to String
Type mismatch: cannot convert from Object to String
Type mismatch: cannot convert from Object to String
Type mismatch: cannot convert from Object to String
Type mismatch: cannot convert from Object to String
Type mismatch: cannot convert from Object to String
Type mismatch: cannot convert from Object to boolean
Type mismatch: cannot convert from Object to boolean
Type mismatch: cannot convert from Object to boolean
Type mismatch: cannot convert from Object to boolean
Type mismatch: cannot convert from Object to boolean
Type mismatch: cannot convert from Object to String
Type mismatch: cannot convert from Object to boolean
Type mismatch: cannot convert from Object to boolean
Type mismatch: cannot convert from Object to boolean
Type mismatch: cannot convert from Object to boolean
Type mismatch: cannot convert from Object to boolean
Type mismatch: cannot convert from Object to boolean
Type mismatch: cannot convert from Object to boolean
Type mismatch: cannot convert from Object to boolean
Type mismatch: cannot convert from Object to boolean
Type mismatch: cannot convert from Object to boolean
Type mismatch: cannot convert from Object to boolean
Type mismatch: cannot convert from Object to boolean
Type mismatch: cannot convert from Object to boolean
Type mismatch: cannot convert from Object to boolean
Type mismatch: cannot convert from Object to String
Type mismatch: cannot convert from Object to String
Type mismatch: cannot convert from Object to String
Type mismatch: cannot convert from Object to String
Type mismatch: cannot convert from Object to String
Type mismatch: cannot convert from Object to String
Type mismatch: cannot convert from Object to String
Type mismatch: cannot convert from Object to String
Type mismatch: cannot convert from Object to boolean
Type mismatch: cannot convert from Object to String
Type mismatch: cannot convert from Object to String
Type mismatch: cannot convert from Object to String
Type mismatch: cannot convert from Object to boolean
Type mismatch: cannot convert from Object to boolean
Type mismatch: cannot convert from Object to boolean
Type mismatch: cannot convert from Object to String
I have tried that way but getting below error....PFA
Error in the component's properties:Type mismatch: cannot convert from Object to String
Type mismatch: cannot convert from Object to String
Type mismatch: cannot convert from Object to Date
Type mismatch: cannot convert from Object to String
Type mismatch: cannot convert from Object to String
Type mismatch: cannot convert from Object to String
Type mismatch: cannot convert from Object to String
Type mismatch: cannot convert from Object to String
Type mismatch: cannot convert from Object to String
Type mismatch: cannot convert from Object to String
Type mismatch: cannot convert from Object to String
Type mismatch: cannot convert from Object to boolean
Type mismatch: cannot convert from Object to boolean
Type mismatch: cannot convert from Object to boolean
Type mismatch: cannot convert from Object to boolean
Type mismatch: cannot convert from Object to boolean
Type mismatch: cannot convert from Object to String
Type mismatch: cannot convert from Object to boolean
Type mismatch: cannot convert from Object to boolean
Type mismatch: cannot convert from Object to boolean
Type mismatch: cannot convert from Object to boolean
Type mismatch: cannot convert from Object to boolean
Type mismatch: cannot convert from Object to boolean
Type mismatch: cannot convert from Object to boolean
Type mismatch: cannot convert from Object to boolean
Type mismatch: cannot convert from Object to boolean
Type mismatch: cannot convert from Object to boolean
Type mismatch: cannot convert from Object to boolean
Type mismatch: cannot convert from Object to boolean
Type mismatch: cannot convert from Object to boolean
Type mismatch: cannot convert from Object to boolean
Type mismatch: cannot convert from Object to String
Type mismatch: cannot convert from Object to String
Type mismatch: cannot convert from Object to String
Type mismatch: cannot convert from Object to String
Type mismatch: cannot convert from Object to String
Type mismatch: cannot convert from Object to String
Type mismatch: cannot convert from Object to String
Type mismatch: cannot convert from Object to String
Type mismatch: cannot convert from Object to boolean
Type mismatch: cannot convert from Object to String
Type mismatch: cannot convert from Object to String
Type mismatch: cannot convert from Object to String
Type mismatch: cannot convert from Object to boolean
Type mismatch: cannot convert from Object to boolean
Type mismatch: cannot convert from Object to boolean
Type mismatch: cannot convert from Object to String
Can you explain ..how to do that...since i am new to talend..
Here is how ot should look like:
1rst tFixedFlowInput replace tSalesforceInput component for the example. The associated schema is composed of 2 fields (name and sheetname).
tFlowToIterate generates a global variable for every incoming field and mark the beginning of an iteration for every row. The configuration of this component is the default one.
2nd tFixedFlowInput generates a flow based on the global variable "row113.name" genrated by the tFlowToIterate component.
Here is how it is configured:
The field "name" is populated by the global variable "row113.name".
tFileOutputExcel generates the desired Excel file using the global variable "row113.sheetname" as the target sheetname:
Be carefull with the ticked options.
That's all.
@uganesh, did this help?
If so, thank's to mark your case as solved (Kudos also acceptedas a bonus).
i have tried as u said..but still getting below error....PFA
Error in the component's propertiesrg.talend.components cannot be resolved to a type
org.talend.components cannot be resolved to a type
org.talend.components cannot be resolved to a type
org.talend.components cannot be resolved to a type
org.talend.components.salesforce.tsalesforceinput.TSalesforceInputProperties cannot be resolved to a type
org.talend.components.salesforce.SalesforceConnectionProperties cannot be resolved to a variable
org.talend.components.salesforce.SalesforceConnectionProperties cannot be resolved to a variable
org.apache.avro cannot be resolved to a type
org.talend.components.api.properties cannot be resolved to a variable
org.talend.daikon cannot be resolved to a type
org.talend.daikon cannot be resolved to a type
org.talend.components.api.properties cannot be resolved to a variable
org.talend.daikon cannot be resolved to a type
org.talend.daikon cannot be resolved to a type
org.talend.components cannot be resolved to a type
org.talend.components cannot be resolved to a type
org.talend.components cannot be resolved to a type
org.talend.components.api.component.ConnectorTopology cannot be resolved to a type
org.talend.daikon cannot be resolved to a type