Hello:
I want to know, how I can exclude one or two columns in ADF pipelines so the value of that column doesn't gets copied or loads into a target table.
Any help on this is greatly appreciated.
Hello:
I want to know, how I can exclude one or two columns in ADF pipelines so the value of that column doesn't gets copied or loads into a target table.
Any help on this is greatly appreciated.
Hi @SunShine-2583,
Just checking in to see if the below suggestion from @nasreen-akter was helpful. If it answers your query, please do click “Accept Answer” and/or Up-Vote, as it might be beneficial to other community members reading this thread. And, if you have any further query do let us know.
Thank you
Hi @SunShine-2583,
We still have not heard back from you. Just wanted to check if the below suggestion from @nasreen-akter was helpful? If it answers your query, please do click “Accept Answer” and/or Up-Vote, as it might be beneficial to other community members reading this thread.
And, if you have any further query do let us know.
Thanks
I haven't tested or look upon it. i will update by weekend.
Hi @SunShine-2583,
If you are using CopyActivity, then:
option#1: uncheck that specific column mapping from CopyActivity --> Mapping --> un-select checkbox for that specific column from Include (please see screenshots below)
option#2: If you want to load static value for any columns e.g., Empty String, you can add additional column from CopyActivity --> Source --> Additional Columns. And then map this column to the target column
Hope this helps! Thanks! :)

6 people are following this question.