Forum Discussion
Join three tables where no fields match (full outer?)
Hi dapperscavenger ,
I would start with table3 and add a custom column where you reference table1.
That will return everything from table1 for each week.
Then join table2 to it based on "From", "To", and "week".
Then add a custom column with the condition that if the value of the expansion from table2 is null, then take the expansion from table1, else take expansion from table2.
Hi dapperscavenger ,
I would start with table3 and add a custom column where you reference table1.
That will return everything from table1 for each week.
Then join table2 to it based on "From", "To", and "week".
Then add a custom column with the condition that if the value of the expansion from table2 is null, then take the expansion from table1, else take expansion from table2.
Brilliant, yes, it was just that first step I was stuck on. I didn't know you could reference another column like that
Had to look up how to write it but it was fairly straightforward: =#"table_name_here"
Thank you