I'm using DomoR to fetch a dataset and a column that should be text is being read in as col_double(). Many values are only digits, but other values contain characters so must be read as a text field. Is there a way I can control for the incoming datatype so I don't lose those character fields? An example of the error message is below.
I'm thinking of ordering the incoming Domo dataset to put character values first...but wanted to ask this question while I work on that.
Thanks!
Warning: 25704 parsing failures.
row col expected actual file
3316 DonorID a double DNM002141 <raw vector>
10350 DonorID a double DNM026515 <raw vector>
13129 DonorID a double DNM004163 <raw vector>
13130 DonorID a double DNM004162 <raw vector>
19087 DonorID no trailing characters AB5KLCAA3 <raw vector>