Skip to main content
Solved

How to change field length?

  • May 30, 2024
  • 2 replies
  • 296 views

vxn43
Supporter
Forum|alt.badge.img+18

I have a text field (attribute) in a table that is 2048 characters in length. I want to change it to 50. What Transformer do I use in FME to achieve this? I am using FME Form 2021. 

Best answer by andrewj74

you can set the schema/attributes in the writer to manual and then set the string length to 50. alternatively if you want to do it within the work flow you could use a schema setter transformer or similar to define it.

 

 

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.

2 replies

andrewj74
Supporter
Forum|alt.badge.img+7
  • Supporter
  • Best Answer
  • May 30, 2024

you can set the schema/attributes in the writer to manual and then set the string length to 50. alternatively if you want to do it within the work flow you could use a schema setter transformer or similar to define it.

 

 


vxn43
Supporter
Forum|alt.badge.img+18
  • Author
  • Supporter
  • May 30, 2024

SchemaSetter Transformer. That’s what I was looking for. Thank you.