Solved

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

  • 19 May 2021
  • 1 reply
  • 1 view

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

icon

Best answer by caracadrian 19 May 2021, 12:01

View original

1 reply

Badge +20

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