question

Adrian-5124 avatar image
0 Votes"
Adrian-5124 asked KranthiPakala-MSFT commented

Problems with Data Factory 'Flatten' option

I am trying to use Flaten inside of Data Factory, I keep on getting the error


The inner value type of the 'Unroll by' structure '{Category Numbers}' must be array type (e.g. structue of arrays, array of arrays)


Whilst I just did a 'Split' operation, this is the preview of the column 'Cateogry Numbers' from the previous step.

126144-image.png

Does anybody have any idea why this is happening?


azure-data-factory
image.png (71.2 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.

1 Answer

KranthiPakala-MSFT avatar image
0 Votes"
KranthiPakala-MSFT answered KranthiPakala-MSFT commented

Hi @Adrian-5124 ,

Thanks for using Microsoft Q&A forum and posting your query.

We have noticed that one of our engineer has already been engaged on the same query in Stackoverflow and shared few inputs on Flatten transformation : Data Factory not recognising array for 'flatten' operation

If you still have further queries, please do share a sample of your input/source data (pls remove sensitive information) and expected output so that we can further assist as needed.

Thank you



  • Please accept an answer and up-vote if it helps. 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.




· 1
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.

Hi @Adrian-5124 ,

We still have not heard back from you. Just wanted to check if the below suggestion was helpful? If it answers your query, please do click “Accept Answer” and/or Up-Vote, as it might be beneficial to other community members reading this thread. And, if you have any further query do let us know.

0 Votes 0 ·