I have an attribute creator running to replace missing values with "NA" in a dataset. I noticed however that if the attribute had parenthesis (e.g. "Actual Values (oct-dec)") would replace every value with "NA" regardless of whether it was missing. Removing the "(oct-dec)" from the attribute name, however, returned the desired result. Can anyone else confirm this or had this experience?
Solved
Attributes with Parenthesis Not Read Correctly?
Best answer by mark2atsafe
OK, I can see what is happening, there is a fault in the gui and it is causing the value of the attribute, not the attribute name, to be passed to the Is Missing test.
I can see a few workarounds.
1) Set the test to Actual Values (oct-dec) = "" (instead of using Is Missing)? It's not exactly the same test, but I think it's close enough for your data.
2) Create a user parameter of type Attribute Name. Set the AttributeCreator test to $(parametername) Is Missing. Set the user parameter to point to Actual Values (oct-dec).
3) As Erik says, try the NullAttributeMapper
Either would work, but #2 is closest to what you currently have. In the meantime I'll file a problem report with the developers to get them to fix the bug, hopefully for 2016.1
Apologies for any inconvenience,
Regards
Mark
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.
+23- Contributor
Maybe off-topic but for replacing empty values the NullAttributeMapper is an excelent choice. It lets you choose any number of attributes and the replacement value in one transformer.
+59- Safer
I can't recreate this (in 2016.0). What functionality are you using in the AttributeCreator? Conditional values? If so, what is the test? Attribute is Empty? Attribute has Value (not)? Attribute=""?
If you can post a small example workspace it would help a lot.
I can't recreate this (in 2016.0). What functionality are you using in the AttributeCreator? Conditional values? If so, what is the test? Attribute is Empty? Attribute has Value (not)? Attribute=""?
If you can post a small example workspace it would help a lot.
I am using a conditional value. I am attaching a small workflow and a snapshot of the -csv- (can't upload csv's I guess - excel file then) I am using. test.fmw actualvalue.xlsx
+59- Safer
- Best Answer
OK, I can see what is happening, there is a fault in the gui and it is causing the value of the attribute, not the attribute name, to be passed to the Is Missing test.
I can see a few workarounds.
1) Set the test to Actual Values (oct-dec) = "" (instead of using Is Missing)? It's not exactly the same test, but I think it's close enough for your data.
2) Create a user parameter of type Attribute Name. Set the AttributeCreator test to $(parametername) Is Missing. Set the user parameter to point to Actual Values (oct-dec).
3) As Erik says, try the NullAttributeMapper
Either would work, but #2 is closest to what you currently have. In the meantime I'll file a problem report with the developers to get them to fix the bug, hopefully for 2016.1
Apologies for any inconvenience,
Regards
Mark
+59- Safer
OK, I can see what is happening, there is a fault in the gui and it is causing the value of the attribute, not the attribute name, to be passed to the Is Missing test.
I can see a few workarounds.
1) Set the test to Actual Values (oct-dec) = "" (instead of using Is Missing)? It's not exactly the same test, but I think it's close enough for your data.
2) Create a user parameter of type Attribute Name. Set the AttributeCreator test to $(parametername) Is Missing. Set the user parameter to point to Actual Values (oct-dec).
3) As Erik says, try the NullAttributeMapper
Either would work, but #2 is closest to what you currently have. In the meantime I'll file a problem report with the developers to get them to fix the bug, hopefully for 2016.1
Apologies for any inconvenience,
Regards
Mark
fyi It's filed as PR#68329, so quote that number if you need to contact our support team about the issue