How to Append a column in this situvation

Help
,
1

Capture

i have a data table .like this with the total
i need to add another row
after adding the row total must be equal to all in D column

1 Like
2

Hi @Tharusha_Fernando

Use builddatatable activity and use this

Thanks
Ashwin.S

3

Hey @Tharusha_Fernando,

This can be achieved with a bit of logical steps.

And here is the workaround for you.

PFA - ExcelWorkout.zip (9.7 KB)

Hope this helps.

Thanks :slight_smile:

1 Like
4

hi @Nithinkrishna its perfect but i wondering how can i use add data row function on this

1 Like
5

no worries i will find it out :slight_smile:

1 Like
6

Hey @Tharusha_Fernando,

You shouldn’t be using a separate Add data row activity.

You would have seen a Multiple Assign and an invoke method which performs adding a data row and you need to just change the data as per you need.

Hope this helps.

Thanks :slight_smile:

7

hi @Nithinkrishna
i got it
thank you

1 Like
8

Cool, Happy Automation :slight_smile:

9

Capture
Capture1056×716 37.9 KB

hi @Nithinkrishna
if their are blank row before & after heading how can i do the same thing like this situation

1 Like
10

Yep @Tharusha_Fernando,

Find the last row which has data in columns and add a new row next to that :slight_smile:

Hope this helps!

1 Like
11

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