ArborRose Coach

Is it possible the source material/data changed? For example, if you have a pdf with an image referenced via a URL, the source in that url may have changed.

Can you parse the values using a CASE statement? Something like the following would create three columns: date, model, serial number containing the values found in the data. CASE WHEN Label='Date' then value as 'Date' WHEN Label='Model' then value as 'Model' WHEN Label='Serial' then value as 'Serial' END

I think we'd need a bit more information to help with the question. I use workbench from importing Excel files. You can select the worksheet and add transformations to perform the type of filtering mentioned.

Sounds like a conflicting thought. The Domo role for admin is described as having full access to everything. So the answer would be “no”.

The select limit was just a test command to identify whether it could see beyond 500k rows. The process I need to create is much more complex.

Thank you MichelleH. The entire data flow was an input table (12 million rows) and a single SELECT where id=XXXX with a limit of 5. I tried a second time to do the output without the limit but for a single person's records and it ran for 25 minutes before I cancelled. That output would have been less than a hundred rows.

Sounds like you are exporting from the dataset rather than viewing it on a card/dashboard. As @MichelleH points out, when you view it the other way the filter is applied.

You should be able to do a calculated field such as CASE when City like '%New York%' then 'New York' when City like '%San Diego%' then 'San Diego' when City like '%San Francisco%' then 'San Francisco' when City like '%Boston%' then 'Boston' when City like '%Topeka%' then 'Topeka' end or CASE when INSTR(City,'New York')>0…

Yes, there is a way to split up timed sections and append. You can import via workbench, or connect to your data with an api. Create smaller datasets such as data_yr_2021, data_yr_2022, data_qtr1, data_qtr2, etc. Then create a workflow and use the append tile to append the datasets. That way, you can pull previous years…

You can create a custom calculated field based on programmed condition. The field could handle the conditional by adding or subtracting from the current date. Such as CASE WHEN campaign_to_date > 2/4/2023 and campaign_to_date < current_date() THEN 1 ELSE 0 END. Then use that as a filter to display when calculated field = 1.

An “api” is a programming interface. Think of it as a program that sits waiting to give you information. When your system contacts their api, your request is asking for updated information. The api responds with the information requested Its appears the usps api is communicating with XML. XML is a mark-up tagged language.…

I use json oAuth connectors. Within the settings configuration there is a section for "Parsing." You can select one of the nested branch heading and expand it to create a dataset based specifically on that branch. For example, one of my branches holds "items". Expanding items creates a schema of columns that are the…

Perhaps this thread will help. https://dojo.domo.com/main/discussion/43640/automatically-export-dataset-from-domo

I had a situation where I needed to purge/truncate and I couldn't figure a way in Domo. I ended up creating a dataset using mysql dataflow where the logic creates a B dataset based on A. The source dataset is never accessed, the output from the mysql becomes the source.

I would look into creating a custom column {formula} with the condition you need. The resulting column can then be used as the color condition. Thus, the new column would show when it dips below or rises above, and the color settings would react to that.

https://developer.domo.com/docs/authentication/overview-4

Looks like you need the client ID and secret. Go to the site for "developer.domo.com". Configure a client for the app and it will produce your id and secret values.

Usando la lógica del modo bestia como CASO CUANDO {condición} ENTONCES X DE LO CONTRARIO Y CUANDO {condición2} ENTONCES X2 DE LO CONTRARIO Y2 FIN. Los agregados como sum se pueden aplicar para sumar diferentes columnas.

Domo has a command line interface (CLI) which includes ways to do things like delete rows. https://domo-support.domo.com/s/article/360043437733?language=en_US