I have 3 files in ADLS Gen2 as ‘DESCRIPTION_CANDIDATENOTES_20231026.txt’ and in Target (SQL) table i have a name as ‘DESCRIPTION_CANDIDATENOTES’ and second file name as ‘DC_RESUMEPDFs_20231026.txt’ and in Target (SQL) table i have a name as ‘DESCRIPTION_RESUME’ and Third file name as ‘DESCRIPTION_Job_Index_20231026.txt’ and in Target (SQL) table i have a name as ‘DESCRIPTION_JOB’. Now i have to load this dynamically in SQL table and i have used Copy activity, inside copy activity sink i have Parameterized table name and given Table name value as @concat(replace(item().name,’_20231026.txt’,”)). Now the data is loading only for ‘DESCRIPTION_CANDIDATENOTES’ table because it removes _20231026.txt.
How can i remove for all 3 files and different table names and load data successfully.

I have tried using Copy activity, inside copy activity sink i have Parameterized table name and given Table name value as @concat(replace(item().name,’_20231026.txt’,”)). Now the data is loading only for ‘DESCRIPTION_CANDIDATENOTES’ table because it removes _20231026.txt.
How can i remove for all 3 files and different table names and load data successfully.