Putting tSalesforceInput out put data row by row into multiple excelfiles

[Anonymous]

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

[Anonymous]

i have tried that way but getting error. PFA.

tal11.JPG
tal12.JPG
tal13.JPG
tal14.JPG
tal15.JPG

[TRF]

There is a lot of screen captures but not the most interesting one.

Share the tSalesforceInput settings and advanced settings.

[Anonymous]

PFA...

tal16.JPG
tal17.JPG

[TRF]

As your captures are not complete, double-check that the fields in your query correspond exactly with the fields of the schema

[Anonymous]

Hi,

As you said i have tried using iterator and fixedflow...

Exception in component tFixedFlowInput_1 (ExtractApexClasses)
java.lang.NullPointerException
at local_project.extractapexclasses_0_1.ExtractApexClasses.tSalesforceInput_1Process(ExtractApexClasses.java:3326)
at local_project.extractapexclasses_0_1.ExtractApexClasses.runJobInTOS(ExtractApexClasses.java:4147)
at local_project.extractapexclasses_0_1.ExtractApexClasses.main(ExtractApexClasses.java:3996)
[statistics] disconnected

Job ExtractApexClasses ended at 11:49 19/09/2018. [exit code=1]

tal18.JPG

[TRF · Accepted solution]

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