RE776
Specifier/Regulator
- Feb 17, 2011
- 16
Hi all,
I have table which consist of 12 columns and over 65000 rows. Except the first three columns, all date are numerical. The unwanted value in the data are blanks, 0 and 1, although I don't want to delete them.
At the moment all data are organised in ascending order based on the format of (dd/mm/yyyy hh:mm:ss). Without the unwanted values, I want to create a new column number each row sequentially by whole numbers instead of dates. As a result, I am hoping to plot a graph using the new column as the x-axis
Mnay Thanks
Felix
I have table which consist of 12 columns and over 65000 rows. Except the first three columns, all date are numerical. The unwanted value in the data are blanks, 0 and 1, although I don't want to delete them.
At the moment all data are organised in ascending order based on the format of (dd/mm/yyyy hh:mm:ss). Without the unwanted values, I want to create a new column number each row sequentially by whole numbers instead of dates. As a result, I am hoping to plot a graph using the new column as the x-axis
Mnay Thanks
Felix