How to convert The Amt into words in azure data factory using azure function?

Ashok Kumar Bollineni 46 Reputation points

Hi All,

I want to convert amount to words in Azure Data Factory.



Requesting you to suggest how can we achieve in Azure data factory.


Azure Functions
Azure Functions
An Azure service that provides an event-driven serverless compute platform.
3,693 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
8,471 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Nandan Hegde 27,241 Reputation points MVP

    Hey @Ashok Kumar Bollineni ,
    As suggested by @KranthiPakala-MSFT , you can use Azure functions(Python) in integration with ADF to achieve this.

    There is an inflect package in python that can help you achieve this.

    number_to_words is the function

    or you can write your own functions to achieve this

    1 person found this answer helpful.
    0 comments No comments

  2. KranthiPakala-MSFT 45,807 Reputation points Microsoft Employee

    Hi @Ashok Kumar Bollineni ,

    Welcome to Microsoft Q&A forum and thanks for your query.

    We do not have out of box feature/function for this conversion from amount number to word. You will have to write your own transformation logic and use that in Function activity or Custom activity of your ADF pipeline to achieve your requirement.

    Please refer to below sources on how to use function activity in ADF pipeline:

    Video: Run Azure Functions from Azure Data Factory pipelines
    Blog by community expert (Disclaimer: Not MSFT owned) :

    Please refer to below few docs which can help to write Azure function:

    1. Create a function in Azure with Python using Visual Studio Code
    2. Create a C# function in Azure using Visual Studio Code
    3. Create a PowerShell function in Azure using Visual Studio Code

    Also please refer to this sample program to convert a given number to words (Source: From public blog - Not MSFT owned) : Program to convert a given number to words

    Hope this information helps.


    Thank you
    Please do consider to click on "Accept Answer" and "Upvote" on the post that helps you, as it can be beneficial to other community members.