SQL DataFlows

SQL DataFlows

Dataset Email Connector

I have a dataset that updates via email connecotr. When the data is sent to the connector the dates turn into integers. Is there a way to fix this?

Thanks

Best Answer

  • Answer ✓

    The best way to fix this would be to build a Magic ETL dataflow with this dataset as the input dataset. You can then use the Alter Columns Tile to change the data types, or you can click on the Input Dataset and click on Data Handling and choose what type you want to change it to as well as clicking on the wheel cog to handle errors. Finally, add an output dataset and then build your cards off of this output dataset.

    **Check out my Domo Tips & Tricks Videos

    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.

Answers

  • Answer ✓

    The best way to fix this would be to build a Magic ETL dataflow with this dataset as the input dataset. You can then use the Alter Columns Tile to change the data types, or you can click on the Input Dataset and click on Data Handling and choose what type you want to change it to as well as clicking on the wheel cog to handle errors. Finally, add an output dataset and then build your cards off of this output dataset.

    **Check out my Domo Tips & Tricks Videos

    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.

Welcome!

It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
Sign In