question

arkiboys avatar image
0 Votes"
arkiboys asked ShaikMaheer-MSFT answered

pivot transform - multiple columns

Is the pivot transformation used for only one pivot column only?
If I would like to pivot on several columns, do I use the transformation per required pivot column?
if I have to use more than one pivot transform then should I use branching?
Thanks

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

1 Answer

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

Hi @arkiboys ,

Thank you for posting query in Microsoft Q&A Platform.

Is the pivot transformation used for only one pivot column only?

Yes its should only with one column. As you see in below screenshot Pivot key defines on which column you would like to perform pivot. This field allows us to pick only one column.
202357-image.png

If I would like to pivot on several columns, do I use the transformation per required pivot column?

yes, you should consider using pivot on them separately with pivot transformation for each column.

if I have to use more than one pivot transform then should I use branching?

yes, you can consider using branching or added multiple source transformations. Any ways will be fine.

Please check below video to understand more about pivot transformation.
https://www.youtube.com/watch?v=ozQYffvt2aI

Hope this helps. Please let us know if any further queries.


Please consider hitting Accept Answer. Accepted answers help community as well.


image.png (68.4 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.