Add new columns with headers at the last of the datatable

I need to get this input excel in a DT
After that i want to add two new columns with headers at the end of the datatable & perform some formula actions on the new columns, & finally i will write the DT to a new excel file
How to do this ?, Attached the input file
Book2.xlsx (11.9 KB)

Input:
IMG-20220804-WA0003
Formula:


Output:

Hi @Praveen_Vs

Have a look on the XAML file and Output File

AddColumnLAst.xaml (11.0 KB)

Book2.xlsx (15.0 KB)

Regards
Gokul

2 Likes

@Gokul001 Thanks, this works great, But in my case I need to use only classic activities in studio, Also I want to create the columns & performing the formula in the temporary datatable only (Output of the Read range), Then finally i will write that Temporary datatable it in to a new excel by using write range.
I dont want to make the changes on my input excel directly.
How can we do this ?

you can use add data column activity

Hey @Praveen_Vs

You can read the Excel data into a DataTable.

Use ForEach and do the calculations in an Assign statement.

Thanks
#nK

1 Like

Hi @Praveen_Vs

Have a look on the XAML file

AddColumnLAst.xaml (23.6 KB)

Regards
Gokul