Append multiple files

• The Table.Combine() function performs an append operation and does not remove duplicate rows
• Any columns which are unique to one of the input tables in a Table.Combine() function will be added to the result set with null values for the rows from the other tables
• The Table.Distinct() function can be applied at the table level to remove duplicate rows
• It can also be applied against a single column or a group of columns