79632533

Date: 2025-05-21 18:02:47
Score: 1
Natty:
Report link

Does anyone have an idea on how to copy the metadata properly, or should I consider restructuring the pipeline for a better approach?

To achieve this, start by copying the list of files as an array. Then use a data flow to transform the array so each file name appears on its own row.

  1. Use the Get Metadata activitys to retrieve the list of files from your source and destination blob container.

  2. Use filter activity to filter out non existing files.

  3. Use a For Each activity to loop through the filtered list and Use append variable to store each file name to a variable in array format.

  4. Create a dummy file with only one value and use the Copy Activity to append the append variable value to it as an additional column.

    • Use a Derived Column transformation to convert the string representation of the array into an actual array format. Apply the following expression to the column containing the array (e.g., Filenames):
split(replace(replace(Filenames, '[', ''), ']', ''), ',')

check this similar issue : https://learn.microsoft.com/en-us/answers/questions/912250/adf-write-file-names-into-file

Reasons:
  • RegEx Blacklisted phrase (3): Does anyone have an idea
  • Long answer (-1):
  • Has code block (-0.5):
  • Contains question mark (0.5):
  • High reputation (-1):
Posted by: Pratik Lad