I have a list of free/paying customer in my db.
I have a list of paying customers in my salesforce.
when i'm adding both fields to a pivottable, I get a "join" which eliminate all the free users from the list as they doesn't appear in salesforce...
How can I create a left join?
Thank you for contacting us.
Good question, first of all, please see the following document which can assist in creating a new Elasticube:
The default join type for a relationship is an inner join, and there is no way of changing this.
However, one can create a custom SQL expression, valid as any other table in the Elasticube. You can place a left join statement b/w the two tables, and then use this table for this specific widget. In this Table's expression place the following statement:
FROM tbl_a a LEFT JOIN tbl_b b
ON a.ID = b.ID
For more info on this, please see:
If you have any further questions regarding this issue, please respond to this ticket.
If you have any further questions or issues, please don't hesitate to open a new ticket.