Copy value from one column to another column

I have to apply filter in Column Subject , If Column Subject has value other than English ,I have to paste values in Column Subject same as of Column Marks .


Are you reading data from xlsx file?

Yes from Excel


Can you share excel screenshots what you want?

Marks column should have same value as Column Subject have like Hindi ,Maths,Social,Science
This will applicable only is Subject is Hindi Maths Social,science

and for English value. the value should be 0 in Marks column


output should be like this


please find the sample.

Main.xaml (12.4 KB) Marks.xls (16 KB)


HI ,

copy value from one column to another.xaml (7.8 KB)

Apply if formula
Use read range then for each row for column Marks
If row(“Subject”).ToString=“English”

There are 80k rows which will take lot of time

Then u can directly use Formula for this say


Use this formula in B2 and then using Read Range, count the rows say


it will give you count
then use Auto Fill Range in that pass Sheet Name and Source Range will be B2 and destination Range will be **`




First use Read Range activity to read your excel worksheet and Use for each loop(helps to iterate the rows in your workflow) and inside for each loop use if condition
If row(0).ToString = “English” then row(1) = “0”
Else row(1) = row(0).ToString
Hope this helps you,Happy Automation!!

What about other subjects? for rest there should be same value

For the rest whatever the subject is there will be write as u can see in ss

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.