In Azure Data Factory v2 (via the Azure Portal), I'm using a csv file as my source file, and an Azure SQL Server table as the destination. How in ADF can I concatenate the values of 3 columns from the csv file into one field in the database table? It's only giving me options for 1-to-1 column mapping. Is a Data Flow element needed for this, or can it all be done inside a Copy Data pipeline?
FYI: this is not the answer to my question: Azure Data Factory mapping 2 columns in one column