Ask Magic ETL questions and get answers from Domo peers
I am having trouble using the pivot function. Attached is a Screenshot of how I am trying to arrange my data. in the above example I am trying to take the columns AAA, BBB, and CCC and place them under a column named measure. As well as create a Compliance column to hold whether or not the measure was open or closed as…
I have a question. I am using APIs now and I would like to know if it is possible to do partitioning using APIs. I know using Magic ETL and using Workbench you can do it, but can you do it using APIs? If I can't is the next step doing recursion? The reason for asking is that I am uploading data daily and would like to add…
Currently i want to append data using the API append method. However, i also want to update the last 2 days 2 a dataset on a cron job so that i do not miss a day. I know partitioning would only keep the unique record. Is it best to use recursion or partitioning for this?
I am pretty new to Domo Developer. I would like to use a python script to daily upload data to a dataset. Here is my script. def append_data_to_dataset(dataset_id, dataframe, access_token): """ Append a pandas DataFrame to a Domo dataset. headers = { 'Authorization': f'Bearer {access_token}', 'Content-Type': 'text/csv' }…
Hi, I have data in this format: Date Island Count 2021-01-02 Aruba 4 2021-02-01 Curacao 9 2021-03-01 Curacao 10 I would like the data to be formatted this way: Island 2021-01-02 2021-02-01 Aruba 4 7 Curacao 9 10 This format is for a table view
I wanted to make a quick post to let you know about an update we made to the Group By tile in Magic. In your instances, you should now see the ability to choose a new options when defining how a column should be aggregated in the Group By tile: Combine distinct strings separated by , This allows you to create an aggregate…
I have a magic etl with a Formula using REGEXP. It doesn't validate but I am wondering if I can even do what I'm doing. I want to extract all values between 2 string characters. Field Value (snip) DECODE(TRUE, IN(LTRIM(RTRIM(deposit_account_type__)),'410'),'Brokered', IN(LTRIM(RTRIM(deposit_account_type__)),'411'),'CDS…
I am working on a report where the data looks like below (sample data): Services : JAS, GAF and YAG fall under the profit center "ABC" and HIG and OPD falls under "XYZ" Date Profit Center Service 1/1/24 ABC 1/1/24 JAS 1/1/24 GAF 1/1/24 YAG 1/1/24 XYZ 1/1/24 HIG 1/1/24 OPD I want my final output to look like below, there…
Hi Team, How to compare two dates values comparison in dynamics with examples coding Thanks, Raja Parthasarathy
Good afternoon, I am trying to mark rows that match up with each other as duplicates so that I can filter them out and only have the truly unique records left. Example So after I mark and filter the only record left will be the third one that doesn't have a match. What is the best way to do this? Thank you in advance
It looks like you're new here. Sign in or register to get started.
Have a Domo product enhancement idea? Submit or upvote on ideas in the Ideas Exchange.
Ask questions about Connectors, Workbench, Cloud Amplifier and get best practices from Domo peers
Ask questions about Magic ETL, SQL DataFlows, DataFusion, Dataset Views and get best practices from Domo peers
Ask questions about Beast Mode, Cards, Charting, Dashboards, Stories, Variables and get best practices from Domo peers
Ask questions about App Framework, Workflows, Domo Bricks, Domo Developer, API and get best practices from Domo peers
Ask questions about Jupyter Workspaces, R & Python Tiles, AutoML and get best practices from Domo peers
Ask questions about Domo Everywhere, Scheduled Reports, Mobile and get best practices from Domo peers
Ask questions about Governance Administration, Approvals, Teams, Alerts, and Buzz and get best practices from Domo peers
Watch how our Customers are using Domo to solve their complex problems.
Domo support and product teams are here to live-answer questions about the most recent product releases. Please post questions in this Forum board for all users to benefit (rather than submitting a support ticket).
Questions or discussions related to Domo University, trainings and certifications