I have a table information and that needs to be transpose like shown below screen shot.
Parcel number is more then 1000 and each parcel bldg type up 30 plus types.
Please can advise to achieve this task.
Thanks in advance
Venu
Question
Create Attribute and Populate values from table
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.
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.
Hi @venu, a well known method is
- AttributeCreator: create a new attribute, name = the value of Bldg_Type, value = the value of Count (see the screenshot below),
- Aggregator (Accumulation Mode: Merge Incoming Attributes): aggregate the features grouping by the Parcel_No,
- AttributeExposer: and then expose the new attribute names (Villa, Residential Apartment, etc.), optionally
[Addition] The BulkAttributeRenamer (Action: Regular Expression Replace) can also be used instead of the AttributeCreator above.
+5- Contributor
Hi @venu, a well known method is
- AttributeCreator: create a new attribute, name = the value of Bldg_Type, value = the value of Count (see the screenshot below),
- Aggregator (Accumulation Mode: Merge Incoming Attributes): aggregate the features grouping by the Parcel_No,
- AttributeExposer: and then expose the new attribute names (Villa, Residential Apartment, etc.), optionally
[Addition] The BulkAttributeRenamer (Action: Regular Expression Replace) can also be used instead of the AttributeCreator above.
any other solution or if any python code
+5- Contributor
In the case, the AttributeCreator (or BulkAttributeRenamer) + Aggregator (+ AttributeExposer) is a well-known solution. Is there any reason for asking other solutions? Just curious?
Maybe I am confused with your solution that's why I asked python code.Can suggest the easiest way to achieve the task.
any other solution or if any python code
A possible approach would be to create a schema feature based on the source data with a Python script and configure Dynamic Schema from the schema feature.
However, it's hard to fully explain all of them here. If you could post a sample source data, I would provide a demo workspace using the data.
Are you using FME 2017.0 or FME 2017.1?
any other solution or if any python code
- create-schema-feature-demo1.fmwt
- create-schema-feature-demo2.fmwt (contains Python script)
Dynamic Workflows: Destination Schema is Derived from a Schema Feature