Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2018-09-18 05:21 AM

Putting tSalesforceInput out put data row by row into multiple excelfiles

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

Labels (3)
Labels
263 Views
0 Likes
1 Solution

Accepted Solutions
TRF
Champion II
Champion II
‎2018-09-19 03:40 AM

As soon as an input field is you cannot use the corresponding globalMap.get.
Try with globalMap.getOrDefault instead.

View solution in original post

263 Views
0 Likes
15 Replies
manodwhb
Champion II
Champion II
‎2018-09-18 05:26 AM

@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.

173 Views
0 Likes
TRF
Champion II
Champion II
‎2018-09-18 05:32 AM

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. 

173 Views
0 Likes
Anonymous
Not applicable
‎2018-09-18 06:20 AM
Author

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

 

 


tal8.JPG
tal9.JPG
tal10.JPG
173 Views
0 Likes
Anonymous
Not applicable
‎2018-09-18 06:25 AM
Author

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


tal8.JPG
tal9.JPG
tal10.JPG
173 Views
0 Likes
Anonymous
Not applicable
‎2018-09-18 06:36 AM
Author

Can you explain ..how to do that...since i am new to talend..

173 Views
0 Likes
Anonymous
Not applicable
‎2018-09-18 06:54 AM
Author

Can you expain how to do this
173 Views
0 Likes
TRF
Champion II
Champion II
‎2018-09-18 07:12 AM

Here is how ot should look like:

0683p000009M0Hj.png

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:

0683p000009M0Ho.png

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:

 

0683p000009M0CG.png

Be carefull with the ticked options.

That's all.

173 Views
0 Likes
TRF
Champion II
Champion II
‎2018-09-18 11:34 AM

@uganesh, did this help?

If so, thank's to mark your case as solved (Kudos also acceptedas a bonus).

173 Views
0 Likes
Anonymous
Not applicable
‎2018-09-18 11:45 AM
Author

i have tried as u said..but still getting below error....PFA

 

Error in the component's properties0683p000009MA5A.pngrg.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


tal11.JPG
tal12.JPG
tal13.JPG
tal14.JPG
tal15.JPG
173 Views
0 Likes