pivot transform - multiple columns

Question

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

Answer 1

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.

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.