Is there a way to convert a dataset column type?
I am trying to import a CSV file into a dataset tag but the numbers come in as strings. What would be the easiest way to accomplish this? Thanks for any guidance.
Is there a way to convert a dataset column type?
I am trying to import a CSV file into a dataset tag but the numbers come in as strings. What would be the easiest way to accomplish this? Thanks for any guidance.
Used DataSetBuilder to create a dataset with the right column types.
Then copy the rows from your dataset with the wrong types into the dataset with the correct column types.
Or it might be as easy to manipulate the CSV to specify the correct types before turning it into a dataset:
The man, the myth, the legend strikes again! Thanks Phil and witman.
Updated code attached.