Changing Column's value in Each Row

Hi Everyone,
could you help me to solve the following easy stuff :

I have a column “j” in my table with numbers. (There is no name of the column)
I need to change all of them to value= value-1;

I don’t know how to adress this column values…

Thank you

1 Like

Yes of couse thats possible buddy
Though ut doesn’t have a column name we can use its column index
And the column index usually starts from 0 for first column
–use a excel application scope and pass the file path as input
–use a read range Activity and get the output variable as datatable named outdt
–use a for each row loop and passthe variable outdt as input
–inside the for each row loop use a assign Activity and mention like this
row(9) = "the value you want to save"
Where 9 represents the column J, as mentioned earlier column index starts from 0 for first column

Thats all buddy you are done
Hope this would help you
Cheers @Slavich

Got it. Thank you so much!

1 Like

Cheers @Slavich