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
  • 5 views

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

View original
Did this help you find an answer to your question?

1 reply

caracadrian
Contributor
Forum|alt.badge.img+23
  • 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.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings