I have a dataset where in some column the numbers are "N/A" and that attribute is in char. Which transformer I can use, so that it can read N/A and gives me N/A in writer. 
Question
How to get rid of "N/A" from Reader to Writer; while N/A is within the main data list
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.
@seasonishere_20 You can use the NullAttributeMapper to set the default value of a set of different attributes. Use the Of If Attribute Value Is: parameter.
+13- Safer
- 383 replies
Hi @seasonishere_20: Welcome to the FME Community! Your question title indicates that you want to get rid of the N/A, while your description indicates you want to keep the N/A in your destination.
If you want to get rid of N/A and have a consistent null value in your destination for any N/A from the reader try using the NullAttributeMapper to replace the N/A with a null value:
Thank you for your reply @nampreetatsafe and @markatsafe
I am definitely gonna those out.
Also, want to get your attention, if the following is okay?
I have used String Replacer for this. Do you think this is also okay? As this also gave me <null> value at the end, which is my goal.
Thank you for your reply @nampreetatsafe and @markatsafe
I am definitely gonna those out.
Also, want to get your attention, if the following is okay?
I have used String Replacer for this. Do you think this is also okay? As this also gave me <null> value at the end, which is my goal.
@seasonishere_20 StringReplacer is fine - but it doesn't set a <null> value, just an empty string. If you're writing to a database, you probably want to use a <null> value.