How to implement rank/max(rank) in a data flow

Krishnamohan Nadimpalli 386 Reputation points
2022-12-23T14:36:33.547+00:00

Hi

I have a dataflow where one of the column name is rank. Now I need to add a new column called "maxrank" , where the value of "maxrank" is rank/max(rank).

273729-image.png

when I use derived column and try max(rank), it is not working. Please let me know on this.

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
6,328 questions
No comments
{count} votes

Accepted answer
  1. ShaktiSingh-MSFT 4,676 Reputation points Microsoft Employee
    2022-12-26T04:40:00.577+00:00

    Hi @Krishnamohan Nadimpalli ,

    Welcome to Microsoft Q&A platform and thanks for using Azure Services.

    As I understand your ask, you want to generate a new column with rank/maxrank in data flow.

    You can achieve this to first calculate max of rank using Window transformation, then Derived Column transformation to write division expression.
    Here is the complete video demonstrating the same scenario: Data Flow Scenario | Calculate Rank/MaxRank | Simple Data Factory Video

    Hope this will help. Please let us know if any further queries.

    ------------------------------

    • Please don't forget to click on 130616-image.png or upvote 130671-image.png 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

1 additional answer

Sort by: Most helpful
  1. MarkKromer-MSFT 5,136 Reputation points Microsoft Employee
    2022-12-24T01:10:13.06+00:00

    There is a Rank transformation, an Aggregrate transformation (for max) and a Window transformation where you can also Rank and Max values based on customized windows of values.