Changing type from an array item - Data Factory

Question

Hi,

I need to change my data to another format by the azure data factory.
The "feeAmount" is an string, and must be changed to a decimal, but I'm getting an error because it's inside an array.

data:

error:

I'm using the Derived Column to make this change. I understood that the problem here is because the object is inside an array.

Could anyone help me to make this?

Answer 1

Hi @Gustavo Loli ,

Welcome to Microsoft Q&A platform and thanks for posting your question.

As I understand your issue, you are trying to convert 'feeAmount' dataType to decimal, but it's throwing error: "toDecimal does not acceptArrayType". Please let me know if my understanding is incorrect.

We need to flatten the complex data to convert it into an individual column first , so that we can apply transformations on top of it. Kindly use Flatten transformation before Derive column transformation to achieve the same.

Adding video for your reference:

To understand more about flatten transformation, kindly checkout 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