Hi ! I wanted to know if there was a way to save the attributes definition (Name, type and width) in to a CSV.
Thanks for the help !
Solved
How to save the Attribute definition in a csv ?
Best answer by markatsafe
Thanks for the answer ! that's a very straight forward transformer to do what i want, but I only have access to the 2020 version of FME and I can't find the transformer so I guess it's only for the newer versions of the software ?
You can use the Schema (any format) instead, or the FeatureReader <schema> port
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.
+2- Contributor
- 606 replies
Hi @fmenewbie_jr ,
Check out the new SchemaScanner transformer - it'll tell you everything you need. Here is an example with an Excel file where it provides the name, data type (<width>, <precision if applicable>). A schema feature will store all of this in a list which you can explode with a ListExploder. Then you can parse/format as needed for your desired output.
If you are using an older release of FME, you can still get this information with a schema feature using either the Schema Reader or a schema feature from the FeatureReader.
Hi @fmenewbie_jr ,
Check out the new SchemaScanner transformer - it'll tell you everything you need. Here is an example with an Excel file where it provides the name, data type (<width>, <precision if applicable>). A schema feature will store all of this in a list which you can explode with a ListExploder. Then you can parse/format as needed for your desired output.
If you are using an older release of FME, you can still get this information with a schema feature using either the Schema Reader or a schema feature from the FeatureReader.
Thanks for the answer ! that's a very straight forward transformer to do what i want, but I only have access to the 2020 version of FME and I can't find the transformer so I guess it's only for the newer versions of the software ?
Thanks for the answer ! that's a very straight forward transformer to do what i want, but I only have access to the 2020 version of FME and I can't find the transformer so I guess it's only for the newer versions of the software ?
You can use the Schema (any format) instead, or the FeatureReader <schema> port
Thanks for the answer ! that's a very straight forward transformer to do what i want, but I only have access to the 2020 version of FME and I can't find the transformer so I guess it's only for the newer versions of the software ?
I combined the two answers and used the FeatureReader with a ListExploder and it worked ! thanks for the help !!