Skip to main content
Solved

Specifying a date using 'Conditional Value'

  • July 11, 2019
  • 2 replies
  • 63 views

Forum|alt.badge.img

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:

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

Forum|alt.badge.img+2
  • 719 replies
  • Best Answer
  • 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:


Forum|alt.badge.img
  • Author
  • 4 replies
  • July 12, 2019

That worked great. Thank you!