Exploring TM1 - a Chartertech Company
Search
Close this search box.

Null Values in a Turbo Integrator Process

I recently needed to check some data I was loading via a Turbo Integrator process in TM1 for Null values. I thought there’d be something like an IsNull (like in Excel), but found no direct TI command to check values being loaded if they are Null or not.

The Solution for Null Values in a TI

As you would know, TM1 only stores values as String or Numeric.

Numeric Null Values

If it is numeric, the value loaded can’t be empty. In this case you would check for a zero value, rather than a null. Thus your if statement would be something like IF ( vValue = 0); blah, blah, blah.

String Null Values

If it is a string (or text) field, then you would need to check for it not equaling a pair of empty single brackets. The if here would then be IF ( sString @= ”); blah, blah, blah.

The Better Way…

Of course, the better way to do all of this is to remove the nulls before you bring the data into TM1.  Then the data loaded into TM1 is clean and ready to use.

  • This field is for validation purposes and should be left unchanged.

Post Sections

Related Posts

John Vaughan

John Vaughan

John is a CPA, MBA and has been a Performance Management consultant for over 25 years. He is the founder of ExploringTM1 and highly regarded for his experience combining financial management with corporate planning, reporting and analysis. He lives in Sydney with his wife, two of his three children, their cat, Freckles, a bunch of chooks and some fish. John is a sports nut, who played rugby until he was 40, started playing football at 54 and loves being outdoors.

Leave a Reply

Your email address will not be published. Required fields are marked *

Log In