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

Question

Hi All,

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

E.g.

Rs. 287.06 -> TWO HUNDRED EIGHTY-SEVEN AND 06/100 RUPEES

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

Regards,
Ashok

Answer 1

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

Answer 2

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) : https://www.mssqltips.com/sqlservertip/6208/integrate-azure-function-into-azure-data-factory-pipeline/

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.