Add new columns with headers at the last of the datatable

[Praveen_Vs (praveen)]

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:

Formula:

Output:

[Gokul001 (Gokul Balaji)]

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

[Praveen_Vs (praveen)]

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

[Ayman_Alabsi1 (Ayman Alabsi)]

you can use add data column activity

[Nithinkrishna]

Hey @Praveen_Vs

You can read the Excel data into a DataTable.

Use ForEach and do the calculations in an Assign statement.

Thanks
#nK

[Gokul001 (Gokul Balaji)]

Hi @Praveen_Vs

Have a look on the XAML file

AddColumnLAst.xaml (23.6 KB)

Regards
Gokul