changing a column data type

newbie123

Hello community,

I have a column that has dates yet the data type for this column is showing as a 'text'. I've been looking everywhere, but I don't see any options that would allow me to change the data type for this column. Where can I find the menu to change a columns data type? Is this even possible in domo? Thank you!

ColemenWilson

There are a few ways to change the column type. The easiest would be in Magic ETL.

1. Open the dataset in Magic ETL
2. Add an Alter Columns tile
3. Choose the column in the alter columns tile and select "Date" for CAST DATA TYPE

MarkSnodgrass

As @ColemenWilson said, there are multiple ways to do this. Here's a video that walks you through some options:

https://youtu.be/QIuuXjiH1JY

ColemenWilson

There are a few ways to change the column type. The easiest would be in Magic ETL.

1. Open the dataset in Magic ETL
2. Add an Alter Columns tile
3. Choose the column in the alter columns tile and select "Date" for CAST DATA TYPE

MarkSnodgrass

As @ColemenWilson said, there are multiple ways to do this. Here's a video that walks you through some options:

https://youtu.be/QIuuXjiH1JY

ArborRose

If you are bringing the data in via API, you may have options to change the data type in the API settings. I use the NoCode oAuth connector, which has a schema definition. If the auto-detect does not recognize the data type you need, you can set it.

newbie123

Thank you all! It's a bit more complicated than I had hoped, but I will follow the steps. Thanks again!

DataMaven

Hi @newbie123 - It's a best practice to only build cards off of datasets which have been through a dataflow, however, I understand that under the new consumption model, that has consequences.

So - If we must be building cards off of raw datasets, here's a beast mode that may help you:

Date(`Date`)

If that doesn't work, you may have leading or trailing spaces. If that's the case, try:

Date(trim(`Date`))