How to filter the data and replace the column values with another in the filtered data at a time

[anjani_priya]

How to filter the data and replace the column values with another in the filtered data at a time.
How to do this.

[pravallikapaluri]

Hi @anjani_priya

Read Range Activity: Read data from Excel/CSV and store it in DataTable variable (e.g., dtData).

Filter Data Table Activity:
Input: dtData
Output: dtFilteredData
Configure the activity to filter the data based on your criteria.

Use a For Each Row activity to loop through each row in dtFilteredData.
Inside the loop, use an Assign activity to replace the column value.
Example: row(“ColumnName”) = “New Value”

Write Range Activity:
Write the updated data back to Excel/CSV.

[anjani_priya]

But I should not change the data in input file but the data should change in output file like the column data should replace in output file

[Adithyeshwar_goud]

you can use
(filter data table) while using it in (foreach row in datatable).
IF you want to compare between to sheets you can use

(vlookup) where we need to have comparable data.

cheers.