Azure Data Factory: precision and scale as parameters to toDecimal() Function

saikumar ellendula 6 Reputation points
2020-06-08T10:40:55.62+00:00

Hi,

providing the precision and scale as parameters to toDecimal() function in Azure data factory is giving "Should be integer literal error". please provide a way to resolve this issue.

Thanks,
Saikumar

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,841 questions
0 comments

4 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Vaibhav Chaudhari 38,746 Reputation points
    2020-06-09T07:18:30.083+00:00

    Feature can be requested at below feedback website. Priority depends on number of votes to that feature. Meanwhile, you will have to find some workaround or just go with fix precision, scale.

    https://feedback.azure.com/forums/270578-data-factory

    If the response helped, do "Accept Answer" and upvote it - Vaibhav

    1 person found this answer helpful.
    0 comments
  2. Kiran-MSFT 691 Reputation points Microsoft Employee
    2020-06-09T02:55:47.867+00:00

    You can only specify fixed values like 10, 2. It cannot be a value from another column

  3. saikumar ellendula 6 Reputation points
    2020-08-05T08:39:13.627+00:00

    any update on this request

    0 comments
  4. saikumar ellendula 6 Reputation points
    2020-08-05T08:39:50.457+00:00
    0 comments

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.