-
Modifying and running a data set set-up by a former employee
Hi everyone- I was trying to edit (and change the auto-run schedule) a data set built via the Salesforce connector that was set-up by a former employee. I had to login with a separate account (into the Salesforce API Connector via DOMO) and I had the "admin" user make themselves the co-owner and remove a few fields on the…
-
Adding a date field into an existing data set using SQL in Magic ETL
Hi Everyone, I have an existing data set that I'm trying to add today's business date to. I need to the data set with the business date field as a part of a data flow. I'm trying to use Magic ETL and use the SQL tool to "Add Transformation". For some reason, I'm not able to nail down what I think should be a trivial query.…
-
Concatenating records from a scheduled run at EOD
Hi everyone, I have a job that loads nearly 5k records (and ~100 columns) worth of data every day towards EOD. I want to be able to create a data set that concatenates the records the data from each day (say either for 2 weeks or 1 month). Ideally for the data set from each day, I will add another column (something to the…
-
Getting Mixpanel Data into DOMO- data schema and syntax query
Hi, I'm trying to get Mixpanel data in DOMO for some custom analysis and have a couple of questions 1. Data model/architecture- Data comes in the form of 17 datasets they seem to call "Reports" and there's a little bit of documentation on what each of these reports means. However, the relational nature of each of the…
