-
Are "Joins" case sensitive
As we all know, Salesforce record IDs are case-sensitive. Has anyone done a join on Record ID? Are joins case sensitive?
-
Magic ETL join operators
Is there going to be a version of Magic ETL that allows for other operators in a join besides "="? I have a situation where I need to use greater than or equal to and I have to use RedShift for this when I could use Magic ETL is other operators were available.
-
Joining or Appending Data Help
I have a dataset (dataset 1) with individual rows as a specific job (with an identifier key) with details including year and country of operations. I have created cards to show the total number of jobs per year. I have another dataset (dataset 2) which shows historical revenue by Year and Country but it is not specific to…
-
View whole output of ETL actions
When building an ETL, how can I view the whole output of an action within the ETL? After running the preview I can only view 100 rows. Example: 1. I join two datasets (that are created within the ETL) to one without knowing if the join-columns are unique. I want to view the datasets that go into the Join action and the…
-
Select specific columns for join in Magic ETL
Hi, I am using Magic ETL for the first time and I am using two datasets and a left join to combine the two. I only want to left join one column from the 2nd table, but I cannot find where I can select for that in Magic ETL
-
Beast Mode - Parent of Parent type join
I have a data set of project items at multiple levels of a project hierarchy: project > task > sub task. I'm trying to build a sort of rollup card that shows the items based on parent link relationships. i.e.: * Project Parent = Self * Task Parent = Project * Sub Task Parent = Task I'd like to be able to have a column that…
-
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 that have different column names and structures, even though each dataset has same columns too, like 'Employee Name' and 'Employee ID'. I tried to join them (using inner join) and run preview with 10k limit, but it showed the…
-
Create a SQL tile within Magic ETL
It would be great to have a SQL tile within Magic ETL where users can write SQL much like what users can do with the Python tile. This would open up the ability to do conditional joins and looping in Magic ETL. It would also remove some of the dependencies on MySQL, Redshift dataflows which can be very slow to run.