Convert String array to Int array in ADF data flow

A A 1 Reputation point
2022-08-24T12:42:19.027+00:00

I have a requirement to convert a string array to integer array in Azure data factory data flow.

Is there a way to do if yes how?

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,441 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Nandan Hegde 29,881 Reputation points MVP
    2022-08-24T16:22:27.913+00:00

    In case if the ask is to map the individual strig values to int than :

    map(myArray,toInteger(#item))

    the below blog can help:
    https://kromerbigdata.com/2021/01/06/transforming-arrays-in-azure-data-factory-and-azure-synapse-data-flows/

    2 people found this answer helpful.