If column have certain value, write another value to another column

Hello guys,


I want to automate the process that, if column “name” contains “Başak” then write into “18” at “age” column at same row.
How can I achive?
Every info will be appreicated.
Thanks

Hello @Basak_Demirel,

Simple…

  1. Read your excel first, u will get output in datatable,
  2. To iterate each row, use for each row activity,
  3. Use write cell activity inside for each row, range would be like B:int_variable

Thanks,
Pankaj

Hi @Basak_Demirel

Please find the below screen shots for your reference. Try and let me know whether it meet’s you expectation.

Feel free to reach us at any time if you have doubts. Thanks.

Happy Automation

Thank you so much!

1 Like

Thank you!

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