Skip to main content
Question

Excel to Shp Attributes

  • January 12, 2018
  • 1 reply
  • 31 views
W

Hi Guys

I am looking for a workflow to Create SHP file attributes from an excel spreadsheet. The problem I am having, is I can only see a way to extract column headings as Attributes. How do I take attribute titles from the cells below the column heading. I hope that makes sense....

Basically, I have an Excel document with Standard Asset data that needs to be included in our SHP files according to discipline. So I have used FME to Test for "Subclass" & "Item_Name", which works great, then I want to extract that list in the "Attribute_name" column to SHP attributes.

Thanks

Martin

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

I

If I understood correctly, you want to "transpose" the table, convert the rows into columns and vise versa. If that is the case you could have a look in the following post:

https://knowledge.safe.com/articles/31701/transpose-a-table-using-fme.html

There is also available in the FME hub the attributetransposer, where you define the attributes that you want to convert its entries into new attributes:

https://hub.safe.com/transformers/attributetransposer

Community Stats

32,207
Posts
122,305
Replies
39,891
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.