Join
Discussion List
-
Joining 3 different datasets to match zip codesHi, I have 3 datasets each with a column containing zip codes. I want to use ETL to create a new da… -
Datasets join issueI'm trying to create a card that can be used to present to budget owners how much they have current…
-
How to apply a filter across 2 data sources with filter column having diff names in the data sourcesI have a column called Frequency (values could be daily, weekly, monthly) in data source 1 and a co…
-
Combining Rows of Data with a common attributeHi, I have a dataset which is product data cross multiple years. In some cases the same buyer bough…
-
MySQL Indexing IssuesWhen setting up Indexes in my SQL dataflow, I notice sometimes that a few columns in the join are n…
-
Datasets join issueI'm trying to create a card that can be used to present to budget owners how much they have current…
-
How to join to a table multiple times?I'm struggling to replicate a simple type of join my company does all the time in SQL Server within…
-
How to Deal with Multiple Date FieldsI have a perplexing issue I'm trying to solve. I have data coming from several different data sour…
-
Zip2Fips - map card issuesWhen I try using a United States map card or a State map card, I get the result in the screen shot …
-
MagicETL/SQL to join datasets using a comparison between valuesI am trying to get a geolocation based on the IPNumber. Dataset a: ipaddress ipnumber (translated…
-
Looking up values from secondary data source but for multiple columns in primary data sourceSo I'm having some trouble wrapping my head around a solution for this scenario in Magic ETL: -I ha…
-
Checklist to diagnose elongated runtimes from adding one simple joinI have a complex data flow (A) that was taking about 7 minutes to run. I have another simple data f…
-
Combining datasets by looking for strings in one columnI have a couple datasets... 1) Product IDs with information 2) Google Analytics data with URLs that…
-
Does Domo have the equivalent of a SQL Server "View"?Maybe I've spent too many years deep in SQL Server. SQL Server has the concept of a "View"…
-
Help on recursive dataflowI have a recursive dataflow that keeps getting hung up from an issue on the join between the recurs… -
Beast mode - Join data from another lineHi Domo community, I would like to achieve a join from a single dataset. Here is the column I hav…
-
Long ExecutionHi people! I'm here again! This time, i have a e long execution problem! I have a table with ra… -
2DataSet Views - Outer JoinHi all, Relatively new to Domo and really enjoying the experience so far :) I've been taking full …
-
Dataflow creation best practice and recommendationA lot of the dataflow creation I do is taking 2 datasets that differ slightly and don't have an eas…
-
Join Function in ETLHi, I am trying to join a table on my DataSet, using the left join function. My original DataSet co…
-
Are "Joins" case sensitiveAs we all know, Salesforce record IDs are case-sensitive. Has anyone done a join on Record ID? Are …
-
Magic ETL join operatorsIs there going to be a version of Magic ETL that allows for other operators in a join besides "…
-
Joining or Appending Data HelpI have a dataset (dataset 1) with individual rows as a specific job (with an identifier key) with d…
-
15Add Formula Rule to Join Tile in ETLIt has been extremely useful in Magic ETL 2.0 to have the Add Formula Rule available in certain til… -
View whole output of ETL actionsWhen building an ETL, how can I view the whole output of an action within the ETL? After running t…
-
Select specific columns for join in Magic ETLHi, I am using Magic ETL for the first time and I am using two datasets and a left join to comb…
-
Beast Mode - Parent of Parent type joinI have a data set of project items at multiple levels of a project hierarchy: project > task >…
-
ETL joining causes an output dataflow that is too big?I am very new in using Domo, so hopefully I can explain my situation well. I have three datasets t…
-
3Create a SQL tile within Magic ETLIt would be great to have a SQL tile within Magic ETL where users can write SQL much like what user…