Skip to main content
Solved

How to create relates, shp and excels that get written in to attribute named folder?

  • May 19, 2021
  • 1 reply
  • 17 views
B
  • PL.shp with attribute 1
  • Excel with Attibute 1 and Attribute 2
  • Attribute 1s relate

I have AttributeFilter set for Attribute 1 to extract Attirbute 1 from PL.shp

 

I need to relate Attribute 1 to Attribute 2, which was not in PL.shp, but is in a related Excel

 

Once the relate is attained from 1 and 2, I need to create a shp that retains the name of Attribute 2 which is then written into a folder with Attribute 2 name.

 

This will have to be done 200 times, so how can I efficiently get from reader to writing 200 shps that need to be in attribute 2 named folders?

 

Then from there, the shp needs to be created into an excel that is placed in attribute 2 named folder.

Best answer by caracadrian

Use FeatureJoiner or FeatureMerger to join the 2 datasources.

Use Fanout Database on the writer, click arrow down button and select Open Text Editor. Add "\\@Value(Attribute2)" and click OK .

fanoutSet the Writer to Shape Name: Attribute 2 (from attribute value dropdown list).

shape_namePS Check if the attribute values used contain invalid characters for folder and filenames.

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.

1 reply

caracadrian
Contributor
Forum|alt.badge.img+23
  • caracadrianContributor
  • Contributor
  • Best Answer
  • May 19, 2021

Use FeatureJoiner or FeatureMerger to join the 2 datasources.

Use Fanout Database on the writer, click arrow down button and select Open Text Editor. Add "\\@Value(Attribute2)" and click OK .

fanoutSet the Writer to Shape Name: Attribute 2 (from attribute value dropdown list).

shape_namePS Check if the attribute values used contain invalid characters for folder and filenames.

Community Stats

32,154
Posts
122,043
Replies
39,812
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.