question

SunShine-2583 avatar image
0 Votes"
SunShine-2583 asked YageshAkhilKandula-3877 answered

exclude column in ADF pipeline

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.

azure-data-factory
· 3
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.

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

0 Votes 0 ·

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

0 Votes 0 ·

I haven't tested or look upon it. i will update by weekend.

0 Votes 0 ·
nasreen-akter avatar image
0 Votes"
nasreen-akter answered

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! :)

78451-img24.jpg




img24.jpg (22.5 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.

YageshAkhilKandula-3877 avatar image
0 Votes"
YageshAkhilKandula-3877 answered

Hi @nasreen-akter
How can we exclude Identity Column in the pipeline copy activity in adf

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.