Problems with Data Factory 'Flatten' option

Adrian 181 Reputation points
2021-08-24T16:48:32.183+00:00

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
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,992 questions
0 comments No comments
{count} votes

Accepted answer
  1. KranthiPakala-MSFT 46,597 Reputation points Microsoft Employee
    2021-08-25T10:26:49.703+00:00

    Hi @Adrian ,

    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.

0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.