filter for the next id

arkiboys 9,556 Reputation points

pipeline is using a lookup into a .csv file
then filter is used to filter for the value of the column, i.e. @activity('FilterNextValue').output.itemName[0] --> This gives the value in the ID field, i.e. 1
But I would like to get the value of the next ID which is in the next row

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

Accepted answer
  1. AnnuKumari-MSFT 30,361 Reputation points Microsoft Employee

    Hi @arkiboys ,
    Thankyou for using Microsoft Q&A platform and posting your query.
    I think the query is similar to what you have asked in the following thread:
    Please let us know if that is not the case , we will try to reproduce the scenario and will serve with the answer.

    0 comments No comments

0 additional answers

Sort by: Most helpful