How to add new column everyday with current date's day

Help Studio
, ,
1

Hello Fellows,

Here I have a workflow and I want whenever I’ll run the workflow the current date’s day should be there as a new column of the sheet.

image

How can we do this?

Thanks in advanced

2

Hi @Vrushali_Gave,
Here is a simple example. You need to have defined table inside the excel table to make it work.

image
image777×484 16.7 KB

Result:

image
image1159×300 9.86 KB

3

Hi @Vrushali_Gave

In addition to the way @Pablito said u can try this way too

You can try something like this

Read range to read the excel and store in datatable dt1

Use assign activitiy to assign as below

day_1= Now.ToString(“dd”)

Use invoke code with code type as c# with passing dt1 as in/out argument and day_1 as input argument with below code

dt1.Columns.Add(day_1)

Next use write range to write the updated dt1

Hope it helps you

Regards

Nived N :robot:

Happy Automation :relaxed::relaxed:

2 Likes
4

@Pablito @NIVED_NAMBIAR Thank you for your response

Workflow: follows some steps

  1. Here I’m reading a sheet from excel.
  2. Comparing two columns from the sheet
  3. If the data match, the bot will select that row cell and today’s date column
  4. Bot will write right tick on that cell
  5. Similarly these steps will perform for 100+ row data

Note: the entire process will execute only once a day

The next day the matching row cell will be the same but the column will be current dates day

Therefore I want to add today’s date column every day and the column will add from “F” name of the column in the excel

@Pablito @NIVED_NAMBIAR I have tried both solutions but not worked for me

Hope you guys got the query

Thanks in advanced

1 Like
5

@NIVED_NAMBIAR @Pablito Any solution???

6

What error u are getting while executing in my answer which I suggested above ?

7

@NIVED_NAMBIAR Instead of adding a column, it’s adding all previous columns

8

Can u share the screenshot of Workflow @Vrushali_Gave

9

@NIVED_NAMBIAR Yes Sure, Here is it

image

image
image701×256 10.2 KB

10

Can u show how the output sheet is ?

11

@NIVED_NAMBIAR These are all my previous columns
image

12

@NIVED_NAMBIAR Could you please help me to find the solution for the above query?

13

Put the direction of DT as In/Out

14

@NIVED_NAMBIAR Again same output

15

Hi @Vrushali_Gave

I had done the following

Input excel file

image

Output excel data

image
image803×217 3.47 KB

It add the new column with column name as current date

Workflow

image
image464×685 12.5 KB

Main.xaml (7.0 KB)

Hope it helps you

Mark it as solution if it resolves ur query

Regards
Nived N
Happy Automation

1 Like
16

@NIVED_NAMBIAR Yeah it worked. Thank you so much

1 Like
17

@NIVED_NAMBIAR It’s replacing today’s date with yesterday’s date. But I want to add today’s date next to yesterday’s date column

How can we do this?

18

Hi @Vrushali_Gave

I got the it correctly by executing same workflow which i had sent you

image
image1087×311 10.9 KB

Regards
Nived N
Happy Automation

19

@NIVED_NAMBIAR I don’t get this kind of O/p

20

Can u show the workflow u had use