Forum Discussion
Solved
Append two tables using left antijoin
I have two tables with same structures (tickets), one contains the all data (unchanging) and the other (new data). Based on the day, the new data can contain rows from the all data. How can I merge t...
workmonitored as a rule of thumb and best practice, do transformation/data preparation as upstream as possible, and as close to the source.
if you can do this in an SQL server then better to do it there so that it can be used for other reports/projects as well instead of doing it in Power BI.
Hope this helps.
hi workmonitored ,
try like:
append them, sort by date column, select key column and remove duplicate rows
or
left outer join the reopenned table to all ticket table based on key column; expand the date column from reopenned , remove the original date column