Joining based on conditions in Magic ETL
Can we make joins based on conditions in Magic ETL? e.g. I want to replicate the below in a join in magic ETL. Can I do it? SELECT dataset_1.* dataset_2.* FROM dataset_1 LEFT JOIN `dataset_2` on (dataset_2.id` IS NULL AND `dataset_1`.`Day` >= COALESCE(dataset_2.date`,dataset_1.date`) )
MySQL joins are not case-sensitive!
I just realized that joins in SQL in DOMO are not case sensitive! This is a huge problem for me and my team. Here's an example: table_1: teammanager_idSalesJohn123MarketingJoe341 table_2: locationmanager_id_2MichiganJohn123CaliforniaJOhn123TexasJOHN123 selecttable_1.*,table_2.*from table_1left join table_2 on…
Sending email alerts to specific users based on dataset email field
Hi everyone, I have a dataset which looks like the following: EmailRunning Latest VersionVersionfred@email.comYes2.firstname.lastname@example.orgYes2.email@example.comNo1.firstname.lastname@example.orgNo1.5 I would like to do the following: If someone is not running the latest version (Running Latest Version = No) then send an email to the person as an…
Does anyone know which chart-type has been used to make these cards in the Domo COVID dashboard?
Does anyone know which chart-type has been used to make these cards in the Domo COVID dashboard? (See screenshot attached) I'm especially curious how the heading is center left, and changes from prior days are shown with arrows
Can we block a dataset from being deleted by anyone apart from the owner?
One of our critical datasets was deleted by mistake by another Admin. Is there an option in Domo to protect a dataset, so that only the Owner of the dataset can delete it, and no one else?
How to use datasets with duplicate column names in a dataflow
Using a JIRA connector, I import a dataset, which has a 1000 columns. There are two columns which have duplicate names. Consequently, I cannot use the dataset in a Domo SQL transform as it gives me a duplicate column error. I also cannot write each column name individually as there are 1000 columns (and I need 999). Is…