Scan on an empty string

Post Reply
Wim Gielis
MVP
Posts: 3105
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.0.9.18
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Scan on an empty string

Post by Wim Gielis »

Hi,

I had to investigate a tricky mapping process with TM1 data going to Hyperion Financial Management (HFM).

Actually, it turns out that using the Scan function with an empty string, to be looked up in a non-empty string, gives a result of 1. Not 0.

Be aware of this :-)
Best regards,

Wim Gielis

IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
User avatar
20 Ton Squirrel
Posts: 71
Joined: Tue Jul 14, 2020 9:53 pm
OLAP Product: TM1
Version: Planning Analytics with Watson
Excel Version: Office 365
Location: Houston, TX

Re: Scan on an empty string

Post by 20 Ton Squirrel »

*peers into a box looking for an empty*

My god, it is FULL of nothings! ×___×

Thanks for posting on this, one of the projects I'm working on is using SCAN in a few spots. I'll keep this in mind.
War teaches us geography, getting old teaches us biology.
User avatar
PavoGa
MVP
Posts: 616
Joined: Thu Apr 18, 2013 6:59 pm
OLAP Product: TM1
Version: 10.2.2 FP7, PA2.0.9.1
Excel Version: 2013 PAW
Location: Charleston, Tennessee

Re: Scan on an empty string

Post by PavoGa »

"Nothing from nothing leaves nothing"

-Billy Preston

Who knew Billy was a TM1 expert back in 1974. :lol:
Ty
Cleveland, TN
Post Reply