Forum Discussion
Solved
ADF pivot vs fabric dataflow pivot
there is a powerful pivot activity in ADF dataflow. the pivot in fabric dataflow gen2 does not seem to have quite the same functionality as that in ADF. for example: in ADF dataflow pivot it has th...
I created the helper row by using Enter Data. Then I copied the generated M code into the main query manually.
But you can do it easier:
You can create it as a separate query by using Enter Data, and then appending that query to your main query by using the menu option for Append queries.
I created the helper row by using Enter Data. Then I copied the generated M code into the main query manually.
But you can do it easier:
You can create it as a separate query by using Enter Data, and then appending that query to your main query by using the menu option for Append queries.
you have been a wonderful help. thanks ever so much.