Hello,
I have a CSV file with 12 columns as data source, but the preview shows V1.......all the way up till v13 (all blanks underneath it - v13 is non existing in the CSV, column 13 has absolutely nothing), also there are 13 variables in the Variable tab. How can I get rid of this v13?
thanks so much!
CSV file as data source, why TI is reading one more column?
-
- Posts: 83
- Joined: Wed Feb 28, 2018 2:20 pm
- OLAP Product: TM1
- Version: 10.2.2
- Excel Version: 2016
-
- Community Contributor
- Posts: 286
- Joined: Fri Feb 15, 2013 5:49 pm
- OLAP Product: TM1
- Version: PA 2.0.9.1
- Excel Version: 365
- Location: Minneapolis, USA
Re: CSV file as data source, why TI is reading one more column?
What harm is variable V13 causing you? You can simply ignore it.
-
- Posts: 83
- Joined: Wed Feb 28, 2018 2:20 pm
- OLAP Product: TM1
- Version: 10.2.2
- Excel Version: 2016
Re: CSV file as data source, why TI is reading one more column?
it's not causing anything really, I just don't understand why it showed up...but I guess I can definitely ignore it sounds like this does happen in TM1... thanks!
-
- MVP
- Posts: 3651
- Joined: Fri Mar 13, 2009 11:14 am
- OLAP Product: TableManager1
- Version: PA 2.0.x
- Excel Version: Office 365
- Location: Switzerland
Re: CSV file as data source, why TI is reading one more column?
Because number of fields = number of separators + 1
If the last field has a trailing separator then this marks the start of a new field.
If the last field has a trailing separator then this marks the start of a new field.
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.
-
- 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:
Re: CSV file as data source, why TI is reading one more column?
Indeed, make sure there are not additional separators.
If an Excel file is the basis for the csv, then make sure that the last cell in Excel (Ctrl-End) matches the last cell of your data.
If not, remove all columns (and rows) that are excessive, save the file (important!) and then save as csv again.
If an Excel file is the basis for the csv, then make sure that the last cell in Excel (Ctrl-End) matches the last cell of your data.
If not, remove all columns (and rows) that are excessive, save the file (important!) and then save as csv again.
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
-
- Posts: 83
- Joined: Wed Feb 28, 2018 2:20 pm
- OLAP Product: TM1
- Version: 10.2.2
- Excel Version: 2016
Re: CSV file as data source, why TI is reading one more column?
Wow that must be it!! thanks so much for your time letting me know!