Forum Discussion
Merging Tables with Date Condition
Hi kellzp22 ,
You can use the Merge fetaure.
Sample data
Jobs:
Bed Allocation:
1.Select 'Merge Queries as New', and then set as follows, click OK.
2.Expand all columns.
3.Add a custom column.
4.Filter out the rows with a custom column value of 1, then remove unnecessary columns, and the final result.
Result:
You can check more details from the attachment.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi kellzp22 ,
You can use the Merge fetaure.
Sample data
Jobs:
Bed Allocation:
1.Select 'Merge Queries as New', and then set as follows, click OK.
2.Expand all columns.
3.Add a custom column.
4.Filter out the rows with a custom column value of 1, then remove unnecessary columns, and the final result.
Result:
You can check more details from the attachment.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
What if some Locations has no data in Allocation table, they will be filtered, I want to keep the null values?