Skip to main content
  • EN

Hi guys,

Pretty new to FME so any help would be greatly appreciated.

My client wants me to use FME to produce an Excel sheet that will show the ‘Expected layers’ and ‘Unexpected Layers’ in a given DWG file and a count of features per layer. I am able to use a Tester to filter for the ‘Expected layers’ and ‘Unexpected Layers’ but I am having trouble making an Excel document that will make each Expected layer the head of its own column. Right now all the Expected layers are coming in together in one column and without a count. I'm assuming I have to breakdown the 'autocad_layer' found in Format Attributes in the reader into new attributes based on the list of ‘Expected layers’ that I have? I have been playing around with Attribute Splitter, Attribute Manager and Attribute Exposer all to no avail.. Hopefully someone can point me in the right direction.

 

Thanks in advance,

 

Fred

Essential_Layers.PNGI realized that all I need is the statistics calculator and click 'Total Count' to get what I am looking for. My next question is how do I get the counts to show up in my excel sheet? Currently all I am getting is a row for each Essential layer..

Any help would be great appreciated.

 

Fred

 

Essential_Layers.PNGI realized that all I need is the statistics calculator and click 'Total Count' to get what I am looking for. My next question is how do I get the counts to show up in my excel sheet? Currently all I am getting is a row for each Essential layer..

Any help would be great appreciated.

 

Fred

 

Hi Fred, make sure to check the 'user attributes' in the writer, these records are the ones that will be written to your Excel. It's possible the definition is set to 'manual' so you will need to add the count manually or you can set the definition to 'Automatic' to write all attributes.

Thanks @louisput! That worked a treat. Much appreciated.

Reply


Community Stats

30,186
Posts
114,572
Replies
37,849
Members
Terms & ConditionsCookie settings
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.