When Joining in ETL, Is there a way to join by a "contain's" option? For Example - I am Joining by part number, however one set of data contains a revision level. So I have (A) 47100-15000 & (B) 47100-15000-A This is common throughout the dataset, is there any way to set the join when matching (A) & (B) to join when (B)…
I'm having an issue with trying to generate a dynamic comparison that can be filtered. What I want to do is to have a series of multiple updates to the dataset where I can pick two dates when updates occured and then see the difference between them (largest gains or losses). Each update has a unique integer identifier in a…
Currently the Facebook Ads connector allows the user to select specific ads or campaigns, or to select "all campains" in the *current list*. However, there doesn't seem to be any provision for the dataset to update with *new* campaigns as they are created, requiring a manual step of recreating the facebook ads dataset…
I'm trying to create a calculated field from an export of email messages that will capture a string AFTER a certain character set. In other words, the field will read something like: How do I remove my payment information from your website? ------------------ Submitted from: https://www.example.com/example I want the…
I have a simple period over period chart that shows sales by quarter for this year and last (grouped bars). Is there a way to add a count of the sales opportunities as a line on a secondary y-axis? Much thanks.
Here's my situation: I am making a card to show survey results, specifically to show response rate. There are 5 questions in the survey and there are currently 16 responses. One of the questions is a multiple choice question that allows for multiple answers. Basically my data table shows a column for question, answer, and…
Why do I have two employees that are not showing up on payroll anymore and they are still active and worked this week? THey also received paychesks last pay period so I went back to check if they were in the system and they have been deleted.
Is there a way to configure Workbench to automatically retry a job if it fails?
Hi I have a specific use case and I am afraid I have hit a limitation of domo. I need to export a dataset and have no access to the cloud. I have too many rows for Domo to handle and times out every time I try run a simple query like select * from dataset where date - 'sample date'. I am looking to break this huge data set…
It looks like you're new here. Sign in or register to get started.