hi all,

this is not an answer but very close to what I want FME to do for me.

and the result I am getting is below.

how do I get the number in cell C8 to be in cell B8?

and perhaps C column name on cell A8?

is this possible to do?

even if I can get the first criteria and then give cell A8 a name would be fantastic.

any suggestions will be appreciated.

thanks.

Hello @fbastian73​ 

There is a interesting post here How to extract and use log information in Workbench (safe.com)

I believe that it be use this can be very useful to you.

Thanks in Advance,

Danilo

If you replace the writer with a FeatureWriter, the output summary feature will contain all this information, which you can then simply send to an Excel writer.

The list _feature_types{} will contain the required elements.

Hi @david_r​ ,

thanks for replying.

I can see in the summary the features i want to go into the output but was unsuccessful in getting FME to write it to an excel file.

I do a group by and still get other things on the excel file.

I can see what i want on the visual preview as shown below but cannot get that to go into the excel file.

below is what is output to the excel file.

not sure what im doing wrong...

Do you have an example that I can refer to please?

thanks in advance.

Have a look at the attached sample workspace.

Note, however, that it will only output the number of features written. If you also need the input features, you'll need to add one or several StatisticsCalculators after your input feature types and add the output to your Excel writer.

Alternatively, you can access the counts from the Python shutdown script, see https://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_Desktop/Configuration/FME_END_PYTHON.htm and the contents of the Python dictionary fme.featuresWritten.

However, getting the values appended to your Excel sheet from the shutdown script might be non-trivial.

thanks very much @david_r​ that was helpful.

cheers.