Map 3D: FDO Labels that skip empty values


In AutoCAD Map 3D, when a feature label’s data field is empty, the field value displays as <Null>.  For example, in a dataset of connected Waterbodies, the labels that use the name field may display <Null> if that field is blank.  This means that on-screen, the label will show the literal 'text'. 

To correct this, you can use a Conversion Function in the label expression.  In this Waterbodies example, the expression starts with the name field and uses the wtrtype field as a fallback whenever a <Null> value is encountered. 

Use the following expression: NullValue(name, wtrtype)

With this setup, waterbodies that have a name will display that value. If the name field is empty, the label will instead display the wtrtype value.

This approach ensures that your labels remain meaningful and visually consistent, even when certain fields contain NULL values.

I hope this helps you create more intuitive and informative labels for your maps in AutoCAD Map 3D!

About the Author

Leo Lavayen

Civil Applications Expert<br><br>As an Applications Expert, Leo is responsible for supporting, training and implementation of software for survey and civil engineering professionals. He has more than 20 years of experience helping large and small, public and private clients in the eastern United States.

More Content by Leo Lavayen
Previous Article
Building Smarter Infrastructure Workflows with IMAGINiT
Building Smarter Infrastructure Workflows with IMAGINiT

Discover how IMAGINiT solutions and Autodesk tools help civil teams modernize workflows, automate tasks, an...

Next Article
Civil 3D: adding dimensions to corridor in section views
Civil 3D: adding dimensions to corridor in section views

Are your corridor dimensions twisted? Look here for how to create AutoCAD dimension like labels for corrid...

×

Get Tips Delivered.

Subscribe to Email Updates.

First Name
Last Name
Country
Thank you!
Error - something went wrong!