apatten

Discussions

Convert all dates to last day of year
I am trying to convert all my dates to the last day of the year in a beast mode. I have a column in my dataset that is already showing the year for the data and have tried this STR_TO_DATE( CONCAT(`YEAR`,'-',12,'-',31),' %Y-%m-%d ') It doesn't seem to work. Any help would be appreciated
Add Data that has been modified in the last 7 days
I have a snowflake dataset that has a modified date column. I want to merge the data that has been modified in the last 7 days to the dataset. Sometimes an order is modified after its placed and we want to capture the new values of the order. I have used this query but its not working SELECT * FROM "TABLE" WHERE…
Is there a way to add rows to a dataset while in Domo where the dataset was a file upload?
I have a file I want to upload using the file upload connector. I will be turning the dataset over to one of the users and want to allow him to edit the dataset as a webform. He will have to add and delete rows and edit rows as necessary. I want to make it as simple as I can for him. Most of the time he will only have to…