How to create flagging sheet

Help Activities
1

How do I create flagging sheet

In flagging sheet there is two columns one is run date and second is status
So run date are randoms bot will on that date which is match with the today’s date and status will done

2

Hi @suraj_gaikwad

Do you want to create a Excel sheet with the name of Flagging.
Then you can take the Build Datatable activity to create a datatable with required columns.
You can use the write range workbook activity to write the data in to the excel.

Hope it helps!!

3

@mkankatala
Can share me the workflow so it’s help me better

4

@suraj_gaikwad

Use lookup Datatable/lookup excel value activity and then use the output of it to write the values yes or no…in look up search for date value

cheers

5

I didn’t get you @Anil_G

6

@suraj_gaikwad

you have two column and first column has dates

so first find the required date row using find/replace activity or lookup activity

then you can use the find/replace activity output to in write cell say you store value in str then use write cell with str.Replace(“A”,“B”) as the column only needs to change and row remains same just use it and give values as “Yes”

image

cheers

1 Like
7

@Anil_G

I have to take dynamic date bcz the date is everytime change so ?

8

@suraj_gaikwad

Just for illustration I have given a hardcoded date…But you can use a variable in that please…the idea remains same

cheers

9

Thanks it’s worked

1 Like
10

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