How to insert data dynamically in data table

[Jasnoor (Jasnoor kaur)]

Hi,

I am new to uipath and i am referring the Training material provided by them and try to do exercise 18 part b and following the same steps and try to insert the values automatically through that but it is showing some error to me.
Can anyone tell me how to insert values dynamically in my existing table through uipath.

Regards,
Jasnoor

[ddpadil (Dilip)]

Hi,
please follow this.

How to add new value (data row) in existing Datatable?

You can try Add data row activity and in the array row property you can pass the row values. {“”,“”,“”,“”,“”,“”,rowval1,“”,rowval2,“”,“”} (should be 10 columns)

How to input vars into data table

HI vvaidya, Unfortunately this did not work for me. I know there’s not much context for you in this xaml sequence but maybe u can see where I am coming from and can help out with the data table building. DOWHileSequence.xaml (67.9 KB) Inside the sequence called ‘Line Item Content Loop’ is where I am pulling out the values and allocating to their appropriate vars…at the end of this sequence is where I want to add to the datatable. Hope this makes sense.

[Jasnoor (Jasnoor kaur)]

Hi @ddpadil,

I have tried it, its not working the way i want.

Regards,
Jasnoor Kaur

[ddpadil (Dilip)]

Hi,
Please attach the workflow.

[Jasnoor (Jasnoor kaur)]

Hi @ddpadil

[ranjith]

@Jasnoor
You can add values as a row in Data Table by using the activity Add Data Row, in this case the data you were inserting should match the existing Data Table Structure.Activity Add Data Column is to insert new column to the data table.
To modify data in particular cell you can use Assign activity, data_table.rows(row_index)(column_index)= value

[Jasnoor (Jasnoor kaur)]

Hi @ranjith,

Can u please provide me an example by doing this, if possible.

Regards,
Jasnoor

[ddpadil (Dilip)]

haha oh boy your taking about database and we’re assisting on excel data table.

[ranjith]

Got confused with Database and Data Table , @Jasnoor you’re facing error in Database not data table

[Jasnoor (Jasnoor kaur)]

Hi @ranjith, @ddpadil,

I am trying to fetch the data from an excel sheet or you can say csv file format and trying to insert those values in my table and facing issues in that.

[ddpadil (Dilip)]

Ok anyways .
then you need to use Alter Table

ALTER TABLE table_name
ADD column_name column-definition

then use insert query

[Jasnoor (Jasnoor kaur)]

Hi @ddpadil,

I am getting this error which i was facing:
Insert : Dynamic SQL generation is not supported against a SelectCommand that does not return any base table information.

Regards,
Jasnoor

[ddpadil (Dilip)]

just make sure insert query has the only those columns which are existed in database table.(Excel columns and database table columns has to match.)

[Jasnoor (Jasnoor kaur)]

Hi @ddpadil,

They are exactly matching.

[ddpadil (Dilip)]

Looks like your table doesn’t have a primary key, you need to set one and check

[Jasnoor (Jasnoor kaur)]

Hi @ddpadil,

The primary key is there in my table.

[ddpadil (Dilip)]

Do you mind trying with “Execute non query” activity
adding to that just make sure you must have similar data type and same property as that of database
if db column datatype is int then you excel column must have int.
similarly what if primary column name in the excel has same values like “10” “10” then db doesn’t accept such value

[Jasnoor (Jasnoor kaur)]

Hi @ddpadil,

Do you mind, if u once try to solve the problem given in the training material of UIPath 18 part b
UiPath Academy - Session 18 - Databases - Practical Exercises.docx - Google Docs…
exercise 2.

[Maheshwar_Matalwar (Maheshwar Mat)]

plz share this sample

[Neha_Goyal]

Hello ,

We are facing the below error when we are using Insert activity to insert datatable into DataBase.
Although we have same column name in Excel and in database table.