Checking CSV File data before loading
-
appleglaze28
- Regular Participant
- Posts: 269
- Joined: Tue Apr 21, 2009 3:43 am
- OLAP Product: Cognos TM1, Planning
- Version: 9.1 SP3 9.4 MR1 FP1 9.5
- Excel Version: 2003
Checking CSV File data before loading
I was wondering I have a cube that a user needs to write a string. I'm gonna extract it before I load it to create a dimension. What syntax can I use to check the elements or column in CSV wehn it comes to the # of character. That if the data is beyond or less than 6 digit it won't load the element to the dimension.
-
Alan Kirk
- Site Admin
- Posts: 6647
- Joined: Sun May 11, 2008 2:30 am
- OLAP Product: TM1
- Version: PA2.0.9.18 Classic NO PAW!
- Excel Version: 2013 and Office 365
- Location: Sydney, Australia
- Contact:
Re: Checking CSV File data before loading
You can use the Long() rules function to check the length of a string variable.appleglaze28 wrote:I was wondering I have a cube that a user needs to write a string. I'm gonna extract it before I load it to create a dimension. What syntax can I use to check the elements or column in CSV wehn it comes to the # of character. That if the data is beyond or less than 6 digit it won't load the element to the dimension.
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.