question

samnick-7321 avatar image
0 Votes"
samnick-7321 asked HimanshuSinha-MSFT commented

Adding two fields to a blob file but in ForEach Copy actvity

Hi,
In my pipeline, i am copying files from one blob to another blob, but i have to add two new columns into the new blob file. This will be a daily activity with 5 daily files. So, For Each childitems (i.e file within the source blob container), copy them to the sink (new blob container), but add the filename and current UTC date to each file as new columns. I am able to achieve this if i dont have a ForEach and have a fixed source. But , when i click on the "Additional Columns" in the source i get the below
89183-image.png



Any ideas on how to circumvent this and add two new columns dynamically.

azure-data-factory
image.png (6.6 KiB)
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hello @samnick-7321 ,
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet .In case if you have any resolution please do share that same with the community as it can be helpful to others . Otherwise, will respond back with the more details and we will try to help .
Thanks
Himanshu

0 Votes 0 ·

Hello @samnick-7321 ,
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet .In case if you have any resolution please do share that same with the community as it can be helpful to others . Otherwise, will respond back with the more details and we will try to help .
Thanks
Himanshu

0 Votes 0 ·

1 Answer

HimanshuSinha-MSFT avatar image
0 Votes"
HimanshuSinha-MSFT answered

Hello @samnick-7321 ,
Thanks for the ask and using Microsoft Q&A platform .
Not sure if you have tried this . You can use the Additional columns in the copy activity . I just tried this and it worked for me .

90046-image.png

90093-image.png


Output


90017-image.png

Please do let me know how it goes .
Thanks
Himanshu
Please do consider to click on "Accept Answer" and "Up-vote" on the post that helps you, as it can be beneficial to other community members



image.png (11.8 KiB)
image.png (34.3 KiB)
image.png (5.1 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.