Add Data Row Dynamically

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

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

1 Like

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 :slight_smile::slight_smile::slight_smile::slight_smile:

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

Thanks @NIVED_NAMBIAR

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

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

yes index<7 i meant

it is not work with me

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

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 ?

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

yes like this

@NIVED_NAMBIAR it is possible ?

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

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

You mean like this…

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

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

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

@NIVED_NAMBIAR I will try Thanks

1 Like

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

Cheers…!

1 Like