Azure Data Factory

Require 2 ADF pipelines,

1st Pipeline - copy multiple excel files from ADL to multiple tables with same name in Azure DB using for each dynamically, don't want individual copy activities, the data on the table should be truncated before copy
e.g
file1.xlsx - copy data to - file1 (table in azuredb)
file2.xlsx - copy data to - file2 (table in azuredb)

2nd Pipeline - the same as above but this will be copy from Azure SQLDB to Azure SQL DW, again truncate first and then copy data

file1 (table in azuredb) - copy data to - file1 (table in azure dw)
file2 (table in azuredb) - copy data to - file2 (table in azure dw)