CODEWITHSUNDEEP
azureazure-data-factory
ZCoder
ZCoder

Reputation: 2349

Azure Data Flow How to get Max id and return only that row which has max id

How to filer max id and return the last row in the Azure Data flow. Or use Filter in data flow and get only last max id.

enter image description here In SQL we Get do it like this

  SELECT Level1Id FROM  [D].[DepartmentGroupLevel1]
WHERE [Level1Id] = (SELECT MAX([Level1Id]) FROM [D].[DepartmentGroupLevel1])

Upvotes: 2

Views: 1687

Answers (1)

Mark Kromer MSFT
Mark Kromer MSFT

Reputation: 3838

It should just be an Aggregate without any group-by. Group by is optional in the Agg transformation.

Upvotes: 1

Related Questions