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
Scan on an empty string
-
- 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
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
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
- 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
*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.
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.
- 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
"Nothing from nothing leaves nothing"
-Billy Preston
Who knew Billy was a TM1 expert back in 1974.
-Billy Preston
Who knew Billy was a TM1 expert back in 1974.
Ty
Cleveland, TN
Cleveland, TN