question

BhavyaMishra-9098 avatar image
0 Votes"
BhavyaMishra-9098 asked HimanshuSinha-MSFT commented

Does ADF provides the functionality to reorder the columns parametrically in Data flow activity.

I have a very basic requirement to reorder the columns in ADF dataflow activity based on columns i provide in parameters.
For eg :
if the order of columns in source is [col5,col3,col4,col2,col1] i want to reorder it to [col1,col2,col3,col4,col5] parametrically.
([col1,col2,col3,col4,col5] -> i want to provide this order during runtime)
Does ADF supports something like this?

azure-data-factoryazure-synapse-analytics
· 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 @BhavyaMishra-9098 ,
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 @BhavyaMishra-9098 ,
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 @BhavyaMishra-9098 ,
Thanks for the ask and using the Microsoft Q&A platform .
You can use a the derived column option .

122445-image.png

In the expression add something like

$columnOrder[1]

122380-image.png

where columnorder is the paramter name

122439-image.png


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



image.png (74.5 KiB)
image.png (10.2 KiB)
image.png (37.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.