Hello There
During a cleaning process, our work space failld process due to the reader attributes with value are 0.
we need to add a process to set the width and type of the atribute in order to avoide such issue
Solved
set writer attributes width and type
+11- Contributor
- 212 replies
Best answer by tigerwoulds
There's a custom transformer called SchemaSetter that will allow you change the string length in your writer.
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.
+51- Celebrity
- 2077 replies
Hi @boubcher
For the Width, you can use the transformer StringLenghCalculator by Attribute. This transformer create a new attribute to hold the results.
Thanks,
Danilo
+51- Celebrity
- 2077 replies
Hi @boubcher
For the Width, you can use the transformer StringLenghCalculator by Attribute. This transformer create a new attribute to hold the results.
Thanks,
Danilo
+11- Contributor
- 212 replies
Hi @boubcher
For the Width, you can use the transformer StringLenghCalculator by Attribute. This transformer create a new attribute to hold the results.
Thanks,
Danilo
- 7843 replies
Hi @boubcher, if your requirement is to change the destination schema definition (attribute names and/or data types) for a dynamic writer feature type, you will have to derive the schema from an external dataset which has desired schema definition or a lookup table which you defined desired schema. See these links to learn more.
- 7843 replies
I cannot see any problem in the screenshot you have posted (I reposted below), and cannot understand correctly what is going on from your question. We need more specific and correct explanation on the conditions and the requirements.
(reposted)
+11- Contributor
- 212 replies
I cannot see any problem in the screenshot you have posted (I reposted below), and cannot understand correctly what is going on from your question. We need more specific and correct explanation on the conditions and the requirements.
(reposted)
Thanks so much for your replay
we did solve the problem by open GeoDb in ARC and do all the adjustments there for now'
but we will see if this issue will be available for the next data provider
I have to get all this QC through FME
anyway thanks, we will advise
+9- Safer
- 284 replies
@boubcher, I have just uploaded a custom transformer to the FME Hub which may solve your problem. It dynamically sets writer string attribute widths based on actual analysis of input attribute values. At the very least maybe the python code can be co-opted for your purposes.
Best,
Nathan
There's a custom transformer called SchemaSetter that will allow you change the string length in your writer.
Hi @boubcher, if your requirement is to change the destination schema definition (attribute names and/or data types) for a dynamic writer feature type, you will have to derive the schema from an external dataset which has desired schema definition or a lookup table which you defined desired schema. See these links to learn more.
Like most things in FME. The most mundane data transformations that could generally be accomplished by a few lines of SQL or R are ridiculously laborious and difficult. Unfortunately my organisation has chosen to use this software so I have to spend most of my days wading through a bewildering variety of transformers along with their associated documentation which give you little idea regarding what they are actually designed to do. I usually have to try a few out before I get anywhere near accomplishing anything like the desired result, returning again and again to this forum. This thing is like shooting cannonballs at sparrows. It sucks.
Hi @boubcher
For the Width, you can use the transformer StringLenghCalculator by Attribute. This transformer create a new attribute to hold the results.
Thanks,
Danilo
That appears to work for one attribute. What if you have to change the width of them all?