What is the difference between a "With All" match type and Append Data Extensions?

depending on the results you are looking for, choosing whether to do a "matching a with all b " relationship (full outer join in sql) or append data extensions can sometimes be a bit tricky in general, when trying to merge data from multiple source data extension (input sources) into one target data extension (output source), append data extensions is the way to go to see the difference in the results, let's look at an example scenario starting with two data extensions that contain customer and lead information match all customers with all leads (full outer join in sql) this will create rows with data from both data extensions (des) based on one or more matching columns in this example, the des will match on id here's what the results will look like after doing a match all customers with all leads (full outer join) append data extensions this action will bring all the rows of each data extension into one new data extension here's what the results will look like after doing an append des