How can we help you today?
Import CSV -- Change type of multiple columns
4 CommentsSorted by Oldest First
Roger Bjärevall
said
over 9 years ago
[This reply is migrated from our old forums.]
Re: Import CSV -- Change type of multiple columns
Re: Import CSV -- Change type of multiple columns
Hi Steve,
Chaning the data type is made only on the column from where the data type drop-down is opened.
You may however use copy/paste of the datatype in the file/table mapper grid in the Import Database Table and the table setup in the New Database Table grids. Copy for example Timestamp from one column and then select the other data type column rows you want to set to Timestamp and paste.
Read more in:
http://confluence.dbvis.com/display/UG91/Importing+Table+Data
Regards
Roger
[This reply is migrated from our old forums. The original author name has been removed]
Re: Import CSV -- Change type of multiple columns
Re: Import CSV -- Change type of multiple columns
Aha! Yes, that works.
I've got a data file that I need to import occasionally that has over 200 columns but I just want them all to be strings, even though some contain numeric data. This method will be much quicker for me.
Thanks!
Roger Bjärevall
said
over 9 years ago
[This reply is migrated from our old forums.]
Re: Import CSV -- Change type of multiple columns
Re: Import CSV -- Change type of multiple columns
Steve,
Great!
In case you haven't figured it out already, you may select multiple cells at once and paste in the new data type.
Regards
Roger
[This reply is migrated from our old forums. The original author name has been removed]
Re: Import CSV -- Change type of multiple columns
Re: Import CSV -- Change type of multiple columns
> {quote:title=Roger Bjarevall wrote:}{quote}
> In case you haven't figured it out already, you may select multiple cells at once and paste in the new data type.
Yes, I realized that. I would have complained if that were not the case.
;-)
anonymous