This solution performs all four operations in sequence, with the output of one step becoming the input for the next.

Step 1 — Remove students from Pune

local!removeCity: remove(

ri!data,

wherecontains("Pune", index(ri!data, "city", ""))

)

How it works

First, extract all cities:

{"Mumbai","Pune","Delhi","Mumbai","Pune"}

Then:

wherecontains("Pune", index(ri!data, "city", ""))

returns the positions of "Pune".

Example:

{2,5}

Finally,

remove(ri!data, {2,5})

removes those records.

Output

Mumbai

Delhi

Mumbai

Step 2 — Rename Mumbai to Bangalore

local!updatedData: a!forEach(

items: local!removeCity,

expression: if(

fv!item.city = "Mumbai",

a!update(

data: fv!item,

index: "city",

value: "Bangalore"

),

fv!item

)

)

How it works

Loop through every student.

If

city = "Mumbai"

replace it with

"Bangalore"

Otherwise keep the record unchanged.

Example

Before

Priya Mumbai

Sam Delhi

John Mumbai

After

Priya Bangalore

Sam Delhi

John Bangalore

Step 3 — Assign grades

local!gradedData: a!forEach(

items: local!updatedData,

expression: a!map(

id: fv!item.id,

city: fv!item.city,

score: fv!item.score,

grade: if(

fv!item.score >= 90,

"A",

if(

fv!item.score >= 70,

"B",

"C"

)

)

)

)

Grade Logic

ScoreGrade

≥ 90

A

70–89

B

< 70

C

Example

90 → A

82 → B

60 → C

A new grade field is added to every student.

Step 4 — Sort by grade

todatasubset(

local!gradedData,

a!pagingInfo(

startIndex: 1,

batchSize: - 1,

sort: {

a!sortInfo(field: "grade", ascending: true()),

a!sortInfo(field: "score", ascending: false())

}

)

).data

How it works

todatasubset() allows sorting a list of maps.

Sorting by

grade

in ascending order produces:

A

B

B

C

C

Grade ascending → A, B, C
Within the same grade, score descending → highest score first

Final Output

{

a!map(

id: 5,

city: "Bangalore",

score: 90,

grade: "A"

),

a!map(

id: 2,

city: "Bangalore",

score: 82,

grade: "B"

),

a!map(

id: 7,

city: "Delhi",

score: 88,

grade: "B"

),

a!map(

id: 4,

city: "Delhi",

score: 60,

grade: "C"

),

a!map(

id: 6,

city: "Bangalore",

score: 55,

grade: "C"

)

}

Flow Summary

Original Data

│

▼

Remove students from Pune

│

▼

Rename Mumbai → Bangalore

│

▼

Assign grades (A/B/C) based on score

│

▼

Sort by grade (A → B → C)

│

▼

Final Result