Add Data Row Dynamically

Help Studio
,
1

Hi Every one ,

I have dateable and I need to write the data in multiple rows dynamically .

like this i have 3 column’s and I need to write data in this columns until finish all data.

A | B | C

1 | 2 | 3

4 | 5 | 6

7 | 8 | 9

could any one help me please

Thanks

1 Like
2

Hi @Dev2,

Yep you can do that. Keep ready your datatable object by either building it or reading from an excel. Then use add datarow activity wherever you want to add. PFB

image
image1312×597 21.3 KB

1 Like
3

Hi @Dev2

Try this way

Use build datatable to build datatable and store in dt1 variable

Use assign activitiy to assign a integer varible let’s say index = 1

Use while loop with condition index<7

Inside it use add datarow with datatrow array as {index, index+1,index+2} with datatable as dt1
After this use assign activitiy

index = index +2

Hope it helps

Mark it as solution if you got it

Regards

Nived N :robot:

Happy Automation :relaxed::relaxed::relaxed::relaxed:

4

Thanks for your replay , I have read the one column’s for one excel and save in dateable , now i have another excel file with 3 columns and i need to write the data from columns as multiple rows , are you getting my point ?

how i can do that with add data row i try that but it is not work

5

Thanks @NIVED_NAMBIAR

I will try that , if it is possible please give me an example

6

@NIVED_NAMBIAR why you write 7 ? in the condition index<7

7

yes index<7 i meant

8

it is not work with me

9

hi i had a doubt are you adding rowdata from a existing datatable ?

10

I have read the one column’s for one excel and save in dateable , now i have another excel file with 3 columns and i need to write the data from columns as multiple rows , are you getting my point ?

11

Like reading a single column and adding it as multiple rows?

12

yes like this

13

@NIVED_NAMBIAR it is possible ?

14

@Dev2… Are you trying to write column values/data as (multiple)rows?

15

@ManiPrajwal_K yes I have multiple data in the column and i need to write the data to another excel which have 3 columns

16

You mean like this…

    Excel -1                                                           Excel2
     Col1                                                  Col1                  Col2                  Col3
      1                                                       1                   2                     3
      2
      3
17

yes , lets see wee have 6 number so it will be like this

18

Hi @Dev2 it is possible

Sorry for delayed response

Check this

Input file
image
Output file
image

Check this workflow
Main.xaml (14.2 KB)

Hope it helps

Mark it as solution if it works

Regards

Nived N

Happy Automation

3 Likes
19

@NIVED_NAMBIAR I will try Thanks

1 Like
20

Seems you want to transpose the cols to rows…
I think this will help you… With explanation too…

Cheers…!

1 Like