create new table to filter the data based on combining multiple tables

[Anonymous]

Hi

Combining with two or more tables, create a new table to filter the data between multiple tables.

Which is the best option to filter data , either merging tables or appending tables in edit query?

thanks

kunuthuri

[v-jiascu-msft]

Hi @Anonymous,

Merging tables adds new data by column while appending tables adds new data by row. So that depends on your data and the purpose. 

Best Regards,

Dale