Page 1 of 1
CSV file as data source, why TI is reading one more column?
Posted: Thu Nov 07, 2019 9:15 pm
by lynnsong986
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!
Re: CSV file as data source, why TI is reading one more column?
Posted: Thu Nov 07, 2019 9:20 pm
by ascheevel
What harm is variable V13 causing you? You can simply ignore it.
Re: CSV file as data source, why TI is reading one more column?
Posted: Thu Nov 07, 2019 10:23 pm
by lynnsong986
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!
Re: CSV file as data source, why TI is reading one more column?
Posted: Thu Nov 07, 2019 11:19 pm
by lotsaram
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.
Re: CSV file as data source, why TI is reading one more column?
Posted: Thu Nov 07, 2019 11:59 pm
by Wim Gielis
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.
Re: CSV file as data source, why TI is reading one more column?
Posted: Fri Nov 08, 2019 1:18 am
by lynnsong986
Wow that must be it!! thanks so much for your time letting me know!