Hello, I need to combine two salesforce datasets in DOMO my question is, do I just need to find what is relational between the two sets (link colomns) i.e. Lead ID or do I need to bring in all of the columns/fields I want to see?
@windy, did Shevy's reply help you out?
Yes. But I also replied and do not see my second response. I had a requestion about beast mode and magic ETL. I was able to create a beast mode formula but was curious now about more information on magic ETL. I am not sure we have this for our account.
Hi Shevy. I must have accidentally hit cancel instead of post.
I just wanted to give some background of what we need in order to report in DOMO. We tend to want to see data historically as well as ‘yt d’, ‘mtd’ etc. So initially I needed to bring in all of our Lead data from the Lead object as well as all the data from our consumer requests (enewsletter opt ins, vacation planning kit requests, ticket purchases) from a custom object ‘Consumer Request’. In order to do this I needed to create a SOQL query for each because they contain millions of records and a SF report will only export a max of 2k rows. Once that was done then I created a data set to combine the two sets by the Lead ID. We also want to report on unique records so I used beast mode to create a filter on distinct Lead ID.
This seemed to work well, but my curiosity now lies with this Magic ETL. After looking at you response, it does not appear that we have this function. I do not see MySQL or Magic ETL. Is this supposed to be available for all DOMO customers?
Here is where it is in our instance
hmmm I will have to check with our admin. It appears we do not hav that. Here my view
@windy, please keep us updated!