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

Question

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).

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

Answer 1

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 or upvote 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

Answer 2

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.