Hello,
I need help in addressing multiple shapefiles in .zip , add some transformers to it and then write it to an excel file with different shapefiles result copying in different sheets in the same excel.
Thanks in advance.
Mukhtar
Question
Multiple shape files to Multiple Excel sheets
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
+62- Celebrity
It's a very generic question so hard for us to give you a detailed answer.
You can use the fme_feature_type attribute (containing the shapefile name) to fill the Excel sheet name, that should take care of most of it. If you don't know beforehand which shapefiles will be present in the zip file you can set a merge filter on the input feature type and make it more dynamic that way.
If you can elaborate more, or give us some sample data, I'm sure we can assist you better.
It's a very generic question so hard for us to give you a detailed answer.
You can use the fme_feature_type attribute (containing the shapefile name) to fill the Excel sheet name, that should take care of most of it. If you don't know beforehand which shapefiles will be present in the zip file you can set a merge filter on the input feature type and make it more dynamic that way.
If you can elaborate more, or give us some sample data, I'm sure we can assist you better.
Hi @redgeographics , let me give an example. I have a zip file of 2 shapefiles. To that, I want to add transformers and get the pivoted results in fme and then write the result of two shapefile in two different sheets respectively with their names populated as sheet names. I need a loop that can work on the first shapefile .Generate the result in the 1st sheet then work on the second shapefile and then generate its result in the 2nd sheet of the same excel. Can workspace runner be used or any batch mode available?
+62- Celebrity
Hi @redgeographics , let me give an example. I have a zip file of 2 shapefiles. To that, I want to add transformers and get the pivoted results in fme and then write the result of two shapefile in two different sheets respectively with their names populated as sheet names. I need a loop that can work on the first shapefile .Generate the result in the 1st sheet then work on the second shapefile and then generate its result in the 2nd sheet of the same excel. Can workspace runner be used or any batch mode available?
Is there any reason why you want to process them separately? If not, stuff like looping or WorkspaceRunners is probably not necessary and the basic process I outlined should work.
@mukhtar_gf I think you're looking for a dynamic workflow as described in this tutorial: Tutorial: Dynamic Workflows . When you add the Shape reader you can use Single Merged Feature Type. When you add the Excel writer use the Dynamic Feature type. This will give you a very simple workspace similar to the one attached. You can then add the pivot. Example workspace (2019.0) esrishape2xlsxw.fmwt