-
rdomo package - dictate schema
I recently encountered a parsing error when creating a dataset using rdomo, where a text field was being interpreted as a date field. Misinterpreting datatypes when pushing to Domo or retrieving from Domo happens, but this was the first time where I couldn't find a solution. Through support, we were able to create a…
-
Can't locate file One Drive
I am using the Microsoft OneDrive for Business connector. I'm able to authenticate. A file in my company was shared with me, and this file has existed for months. However, while I can access it as a user, I'm unable to access it through the connector. I've tried via name, path, and a number of other configurations. I get…
-
R Plugin Creating Dataset with correct datatypes
(Unsure if this is the right forum location) So I have a dataframe I've created in R. A few columns have been converted into num datatype, with values of 1, 2, and NA. When I create the dataset in Domo using the R Plugin, every single column is coming in as a string. My dates and nums have been turned into strings. The…
-
Append not finding new rows after initial import
Ok, so I'm using a date field in my replacement variable. I initially set the value equal to a date at the beginning of my range (right before the range starts in the data). I include the date field in my SELECT, WHERE, and ORDER BY. In my WHERE I added another date to be the cap to try and troubleshoot the issue of not…
-
MySQL UNION not removing duplicates
I have a historical dataset (HIST) and one that's updated daily (DAILY). The DAILY contains the past 3 days worth of data. So the statement: SELECT * FROM DAILY UNION SELECT * FROM HIST ...should produce a combined dataset, with no duplicate rows. But, I'm getting duplicate rows in my output as if I had used a UNION ALL…
