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

[NIVED_NAMBIAR (NIVED N)]

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

Happy Automation

[Vrushali_Gave]

@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

[Vrushali_Gave]

@NIVED_NAMBIAR @Pablito Any solution???

[NIVED_NAMBIAR (NIVED N)]

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

[Vrushali_Gave]

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

[NIVED_NAMBIAR (NIVED N)]

Can u share the screenshot of Workflow @Vrushali_Gave

[Vrushali_Gave]

@NIVED_NAMBIAR Yes Sure, Here is it

[NIVED_NAMBIAR (NIVED N)]

Can u show how the output sheet is ?

[Vrushali_Gave]

@NIVED_NAMBIAR These are all my previous columns

[Vrushali_Gave]

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

@Pablito @NIVED_NAMBIAR Thank you for your response Workflow: follows some steps Here I’m reading a sheet from excel. Comparing two columns from the sheet If the data match, the bot will select that row cell and today’s date column Bot will write right tick on that cell 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 a…

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

[NIVED_NAMBIAR (NIVED N)]

Put the direction of DT as In/Out

[Vrushali_Gave]

@NIVED_NAMBIAR Again same output

[NIVED_NAMBIAR (NIVED N)]

Hi @Vrushali_Gave

I had done the following

Input excel file

Output excel data

It add the new column with column name as current date

Workflow

Main.xaml (7.0 KB)

Hope it helps you

Mark it as solution if it resolves ur query

Regards
Nived N
Happy Automation

[Vrushali_Gave]

@NIVED_NAMBIAR Yeah it worked. Thank you so much

[Vrushali_Gave]

@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?

[NIVED_NAMBIAR (NIVED N)]

Hi @Vrushali_Gave

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

Regards
Nived N
Happy Automation

[Vrushali_Gave]

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

[NIVED_NAMBIAR (NIVED N)]

Can u show the workflow u had use

[Vrushali_Gave]

@NIVED_NAMBIAR Yes sure, Here is it