Community Forums

Discover best practices and find answers to your questions with advice from fellow Domo users.

Recent Discussions

Joins: Automatic Identification of Relationship Direction
Please add: Automatic identification of relationship direction within a Join tile. An option to amend this relationship direction (where appropriate) within the Join tile. E.G A drop-down with 1-2-1,1-2-Many, Many-2-1, Many-2-Many (inc warning) e.t.c A visible representation of this relationship direction with ERD arrows…
Hi I had a question about creating a view by joining two tables in the data tab of a card.
I am trying to join two tables to create a view in a DOMO card but I am running into a weird issue. Table 1 has 42.3 million rows and table 2 has 158K rows. When I do a left outer join to table 1 I am getting 297 million rows of data. Why am I getting more data than the two tables themselves it should be less data, not…
Data Join Confusion - Magic ETL
Hi, I'm trying to join two sets of data together (assignments submission data & assignment summary data) For the output, I am trying to get a list of all assignments with a due date in a date range that have not been submitted by the students. The assignment submission data has a row for every student that lists every…
Creating a join expression with multiple criteria
Hi, I am a little stuck trying to create a join expression. In the table below, I want to join the Cost using the active From date to a table of data with multiple dates. For example, I have data from 1/31/24 thru today. For Campaign 1, I want to use the cost of .5 up to 1/31/2025 and then moving forward after that, use .6…
Join in ETL
Question: I have two separate databases where there is only one common column, which is the "salesperson." The first database contains sales values for each salesperson. The second database contains the area of operation and products associated with each salesperson. I plan to create a new column to calculate the…
Join Data in ETL
I have two datasets: one for home country and another for citizenship. Both datasets share two common columns: country and student_id. In the home country dataset, the country column is 70% populated, leaving 30% of the rows as null. I want to fill these null values in the home country dataset using the corresponding…
DataDog Dataset Join to Showcase Monitors and Events Together
Hello, I am trying to join the DataDog Events and DataDog Monitors datasets but I have not found any way to join them. I want to show every event that has occurred for each monitor over time with their severity. I have been looking at each of the respective datasets IDs and I could not find a primary/foreign key pair to…
Transforming an ETL
Hello! I am trying to edit an ETL with three input datasets.. My goal is to get the 'GLAcct' row of data from the "GLAC PARTS (EZ TEST)' input dataset into the GLBD_V2 datset. Currently, the join is taking the 'GLAcct' under the input dataset 'GLBD_v2'. The request I received was to add a column onto one of our cards…
Group By Issue
I need assistance with identifying transactions that net out to zero in a large dataset. Each row in the dataset represents a unique transaction with its own ID. Objective: Identify pairs of transactions that meet the following conditions: Same client ID Same transaction type ID Same transaction date The sum of their…
Income Statement: How do I join 'Chart of Account' table & 'GL Records' correctly
I have 2 tables: Chart of Account - Right Table: notice that there are Addon Repairs, Restocking Charges, Contractor Discount in 'Cost of Sales Others' 2. GL Records (for all branches from Feb 2024 - Sep 2024) - Left Table Problem: I've tried both Full Join, Left Join (key: gl_account_id) then make a pivot table (filter a…

Welcome!

It looks like you're new here. Members get access to exclusive content, events and more. Sign in or register to get started.