Hello I have been given some data to process daily, it has a date column but its formatted as Text, and has a short month, for example it looks like: 01 Jan Data in DOMO looks like: There is another column that has the full month name and the year (as a month summary) so i have trued to split out the Short and Date Summary…
Input into formula tool is 2019-01-02 07:30:00 AM, formula is STR_TO_DATE(TimeIn1,'%Y-%m-%d %h:%i:%S %p'). Validate formula checks out, but error is Failed to parse date/time: Error at or near character 11 in string /2019-01-15 7:30:00 AM
I have a field with letter and numeric values (ex. "John Doe" vs. "12345"). My goal is to filter to leave the numeric values and change the column type to Integer. Does anyone have any ideas on how to do this in ETL? Trying to think of a Case when statement & filter option.
Hi all, so I want to use the Domo API's to do partitioning. That is, I want to send data daily, and I do not want the data there to be overwritten. I am trying this but I think it is being overwritten: https://api.domo.com/v1/datasets/{dataset_id}/data?updateMethod=PARTITION Is this the correct way to upload via partition?…
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…
It looks like you're new here. Sign in or register to get started.