Hi, I joined two tables in model explorer
explore: tableA{
join: tableB{
sql_on: ${tableA.account_id} = ${TableB_budget_id};;
relationship: many_to_one
type: full_outer
}
}
when using the date filter added in the dashboard the rows that not matched in the two tables didn’t shown. it act like left join and not full outer join.
because the filter add the condition to where clause instead of join on clause.
How to have the result of the ‘full outer’ after using the filter?
Thank you
I find the solution by using merging in explorer,
But if there is another option I will be glad learning it