Write Cell activity issue

image

Hey

I have doubt How can I write “Check Manually & Tool” for values available in column E. And follow the loop for each row using classic activities.

Regards
Naman

Hi @Naman_Arora

for each row in data table should be used and within the for each use the CurrentRow(4) for the column E

The index number starts from 0

For A column the index number is 0
B column the index number is 1

So, for the E column the index number will be 4

So use the assign activity and assign CurrentRow.ByIndex(4) = value .

Regards

Hi Naman_Arora,

Could you please elaborate on the issue?

Do you want the output “Check manually” if a row contains ‘Cricket,’ and if so, do you want to write this value ‘Cricket’ into a separate cell?

@tkiran Hi

I want the bot to write Check Manually in B2 if cell A2 contains cricket.

Can you tell me how can I perform the same for each row using classic activity ?

Regards
Naman

Hi @Naman_Arora

Can you try the following?

Input:

image

Output:

image

BlankProcess16.zip (967.1 KB)

Regards,

@lrtetala
Hi The above condition works fine.

iI tried to write Manually for Golf and other sport.

I used this condition - CurrentRow(2).ToString.Contains(“Golf;Cricket;Football”).

But It is only manually for Cricket only.

rest works fine.

Regards
Naman

@Naman_Arora

Try this

CurrentRow(0).ToString.Contains("Cricket") Or CurrentRow(0).ToString.Contains("Golf") Or CurrentRow(0).ToString.Contains("Football")

Input:

image

Output:

image

BlankProcess16.zip (969.6 KB)

Cheers!!

@Naman_Arora

Hope you got the solution for your question if yes please mark it as solution else happy to help