Solved

Specifying a date using 'Conditional Value'

7 years ago
July 11, 2019
2 replies
121 views

tbarnard93

I have a dataset, where one of my columns is a 'pack date', unfortunately some of the values within this column are null.

I am trying to use Conditional Value within the attribute manager to give a dummy date wherever a null value appears in my table.

So far I have:

If Pack Date ATTRIBUTE_VALUE_NULL as my test condition.

How would I assign an attribute value of, say 01/01/1990?

Thanks,

Tom

Best answer by hollyatsafe

Hi @tbarnard93,

In the Parameter Condition Definition wizard after you have set the Test Clause there is a parameter at the bottom of the window that defines the new Attribute Value when this condition is met:

Then for the 'Else' statement leave it as No Action so anything that isn't Null is not changed meaning your overall Condition Statement will look like this:

View original

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.

H

+2

hollyatsafe
Best Answer
7 years ago
July 11, 2019

Hi @tbarnard93,

In the Parameter Condition Definition wizard after you have set the Test Clause there is a parameter at the bottom of the window that defines the new Attribute Value when this condition is met:

Then for the 'Else' statement leave it as No Action so anything that isn't Null is not changed meaning your overall Condition Statement will look like this: