Forum Discussion
Solved
Append two tables based on latest date column
Hi, I am new to Data Factory and need help with the following use case: Simplified version is that I have two tables in a lake house, [table A] where weekly data is staged and [table B] the main tab...
I guess this is a similar scenario: https://learn.microsoft.com/en-us/fabric/data-factory/tutorial-setup-incremental-refresh-with-dataflows-gen2
If you choose to follow this tutorial, you will probably need to tweak it a bit to suit your case.
Hi Learning_Fabric ,
Your solution is great, frithjof_v . It worked like a charm! Here I have another idea in mind, and I would like to share it for reference.
I think when you use pipeline you can change the join type to suit your needs.
In other areas, you can refer to what frithjof_v said for specifics.
Best Regards
Yilong Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.