-
Beginner - managing a wide table, creating sum of..
Hi there, newbie here. I have a wide table with a column format a bit like this: name, question1, OPP1, EXP1, ACH1, question2, OPP2, EXP2, ACH2 I will need to make calculations for each row on the values (integers) grouped by OPP, EXP, ACH. I thought to create new columns with the sum of OPPx, EXPx and ACHx (where x…
-
Importing Large Data Set from Mongo DB
Hi, I am having a lot of errors importing data from my mongoDB (using the MongoDB V2 connector). The data contains around 10 million Json documents. The connector is working as I have successfully imported previously and I am able to run the importer when the row count is limited to 100,000. What is the best path to take…
-
Using Percentiles to Bucketize in Beast Mode Query
Hi All, I have a table with a text dimension (Name) and an associated measure (Score). I wish to do the following: Calculate if the Score for each Name is in the top 20th percentile of all entities (highest) If the Name is inside the 20th percentile, do not update the Name. If the name is outside of the 20th percentile,…
-
Magic ETL - Change column types and merge files
Hi, I am merging 7 data sets into one. I would like to change the column types on all 7 of the source files before merging into the output data set. 2 columns in each file are "text" columns, but I wish to change them to date type. Some of the data contains "n/a" as a string. When I ran a simple Set Column Type ETL on this…
-
No Code JSON - Upload File Containing JSON Data
I am getting the below error message when trying to manually import a JSON file using the no-code JSON connector. "Domo is ready, but there was an error parsing an expected JSON response from the API. Please check that the API is returning the expected data" I am using a JSON account with no parameters other than the name…
