FileName in Issue

Question

Hello Team,

I have multiple files in the Blob storage and the file data has to be copied into DB Table the table name as a file

Blob storage :

Azure SQL Table name :

1. Basic data
2. Plant Data

I am using the pipeline :

And i am getting error in copy activity :

Please advise how to remove the .csv extension.

Thanks in advance

Answer 1

Hi @Rohit Kulkarni ,

Would you please try:

@substring(item().name, 0, lastindexof(item().name, '.csv'))  

Thanks!