Hi @Debbie Edwards ,
Thanks for using Microsoft Q&A platform and thankyou for posting your question here.
As I understand your query, you are trying to flatten two properties here, 'material' and 'meta' . However, it's not working and throwing this error 'Only one unrollby function allowed with a single expression'. Please let me know if my understanding is incorrect.
First of all, you can only unroll a property which is of array type. Here , I can't see 'meta' is an array. To convert 'meta' to an array value, you can use split function
in derived column transformation
. Post that you can use another flatten transformation
to unroll 'meta'. Also, I assume 'material' is one of the hidden properties in the image which should get flattened as it's an array.
It would be better if you could share the whole JSON content for us to reproduce the scenario and provide better help.
For more details on Flatten transformation, kindly watch this video: Flatten Transformation in Mapping Data Flow in Azure Data Factory
Hope this will help. Please let us know if any further queries.
------------------------------
- Please don't forget to click on
or upvote
button whenever the information provided helps you.
Original posters help the community find answers faster by identifying the correct answer. Here is how - Want a reminder to come back and check responses? Here is how to subscribe to a notification
- If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators