%3CLINGO-SUB%20id%3D%22lingo-sub-1747160%22%20slang%3D%22en-US%22%3ERank%20transformation%20and%20find%20function%20in%20mapping%20data%20flows%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1747160%22%20slang%3D%22en-US%22%3E%3CP%3EThis%20week%20in%20Azure%20Data%20Factory%2C%20mapping%20data%20flow%20is%20getting%20two%20new%20features!%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThe%20rank%20transformation%20is%20a%20new%20%3CI%3Eschema%20modifier%26nbsp%3B%3C%2FI%3Edata%20flow%20transformation%20that%20allows%20you%20to%20generate%20an%20order%20ranking%20based%20upon%20different%20sort%20conditions.%20Choose%20whether%20or%20not%20you%20wish%20for%20the%20sorting%20to%20be%20case%20sensitive%20or%20if%20you%20want%20a%20dense%20rank!%20Learn%20more%20from%20our%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fazure%2Fdata-factory%2Fdata-flow-rank%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Erank%20transformation%20documentation%3C%2FA%3E.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22rank-configuration.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F224300iE5CC2D77E6B8D4ED%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22rank-configuration.png%22%20alt%3D%22rank-configuration.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EWhen%20running%20the%20above%20configuration%20on%20basketball%20data%20provided%20by%26nbsp%3B%3CEM%3Ebasketball-reference.com%3C%2FEM%3E%20on%20the%202019%20NBA%20season%2C%20the%20following%20%22pointsRanking%22%20column%20is%20generated%3A%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F224301i0C29185A7D9AC5F6%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThe%20%3CEM%3Efind()%3C%2FEM%3E%20function%20takes%20is%20a%20new%20function%20takes%20in%20an%20array%20and%20a%20filter%20condition%20and%20returns%20the%20first%20value%20that%20satisfies%20that%20condition.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EFor%20example%2C%20say%20you%20have%20an%20integer%20array%20%5B10%2C20%2C30%5D%20and%20want%20to%20find%20the%20first%20value%20that%20is%20greater%20than%2010.%20In%20mapping%20data%20flows%2C%20you%20can%20enter%26nbsp%3B%3CEM%20style%3D%22font-family%3A%20inherit%3B%22%3Efind(%5B10%2C%26nbsp%3B20%2C%26nbsp%3B30%5D%2C%26nbsp%3B%23item%26nbsp%3B%26gt%3B%26nbsp%3B10)%26nbsp%3B%3C%2FEM%3Eand%20the%20output%20would%20be%2020.%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EFor%20more%20information%2C%20see%20the%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fazure%2Fdata-factory%2Fdata-flow-expression-functions%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Emapping%20data%20flow%20expression%20function%20reference.%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-1747160%22%20slang%3D%22en-US%22%3E%3CP%3ENew%20this%20week%20in%20Azure%20Data%20Factory%3A%20Generate%20a%20rank%20column%20for%20your%20data%20using%20the%20rank%20transformation%20and%20find%20values%20in%20an%20array%20column%20using%20the%20find%20function%20in%20mapping%20data%20flow%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22rank-configuration.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F224303iFA96778CBE70437F%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22rank-configuration.png%22%20alt%3D%22rank-configuration.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1747160%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAzure%20Data%20Factory%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMapping%20Data%20Flows%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Microsoft

This week in Azure Data Factory, mapping data flow is getting two new features!

 

The rank transformation is a new schema modifier data flow transformation that allows you to generate an order ranking based upon different sort conditions. Choose whether or not you wish for the sorting to be case sensitive or if you want a dense rank! Learn more from our rank transformation documentation.

 

rank-configuration.png

 

When running the above configuration on basketball data provided by basketball-reference.com on the 2019 NBA season, the following "pointsRanking" column is generated:

image.png

 

The find() function takes is a new function takes in an array and a filter condition and returns the first value that satisfies that condition.

 

For example, say you have an integer array [10,20,30] and want to find the first value that is greater than 10. In mapping data flows, you can enter find([10, 20, 30], #item > 10) and the output would be 20. 

 

For more information, see the mapping data flow expression function reference.