First of Month ETL Action Item

edited February 17 in Ideas Exchange

Would love to see some custom ETL Action Items for combinations that are most common in Magic ETL. For example, we use a First of Month column for almost every data set, but have to re-create it each time by doing:

  • Get year of datecol (ex. 2019)
  • Get month of datecol (ex. 6)
  • Set constant day of 1
  • Combine with "-" (ex 2019-6-1)
  • Set Column Type to Date


First of Month.JPG







I realize it's not difficult to do this set of action items each time we create a new data set, but this seems like a popular field many companies use and it'd great to see Domo incorporate trends it sees in data flow creations and start releasing custom action items. (If someone else has a better way to do this, please let me know!)

2 votes

· Last Updated

This discussion has been closed.