azureazure-data-factory

How to add an file extension to Azure Data Factory expression

I have the following Azure Data Factory expression

@{pipeline().parameters.Zone}/@{pipeline().parameters.Classification}/@{pipeline().parameters.Area}/@{pipeline().parameters.Domain}/@{pipeline().parameters.TableName}

How to add the extension .csv to the TableName? I tried the following:

@{pipeline().parameters.Zone}/@{pipeline().parameters.Classification}
/@{pipeline().parameters.Area}/@{pipeline().parameters.Domain}
/@{pipeline().parameters.TableName,'.csv'}

But I got the error:

Parameter TableName,'.csv' was not found
Solution 
  • @{pipeline().parameters.p1}/@{pipeline().parameters.p2}.csv

    or Try using concat function :

    @concat(pipeline().parameters.p1,'/',pipeline().parameters.p2,'.csv')