hello! is it possible to join 2 tables (
hello! is it possible to join 2 tables (in the model/worksheet) in this way? I am not able to find a way to do this in the new modeling ui
Column A in both tables must match
Column B in both tables must match or be null in table 2
inner join Table2 on Table1.ColumnA = Table2.ColumnA and (Table1.ColumnB = Table2.ColumnB or Table2.ColumnB is null)
thank you!
Column A in both tables must match
Column B in both tables must match or be null in table 2
inner join Table2 on Table1.ColumnA = Table2.ColumnA and (Table1.ColumnB = Table2.ColumnB or Table2.ColumnB is null)
thank you!
