cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Is there a quick way to upload around 3000 records in a data table

Newbie

Is there a quick way to upload around 3000 records in a data table

Please let me know if anyone of you is aware of a quick way to upload around 3000 records in a data table.

Regards,

Hemant

1 REPLY 1

Re: Is there a quick way to upload around 3000 records in a data table

Hi Hemant Rastogi​,

Per my understanding; following steps can be used:

1. Import the csv file to the file repository.

2. The path of the csv file can be taken using GetFileInfo service.

3. Then, map the path from GetFileInfo service to LoadText service which will provide the csv content.

4. Identify the Primary key in your Data; if there is none add a Id field which will primary the Primary key. (In this case we will have to iterate through the table to add distinct value to the primary key field)

4. Create the DataShape which defines the structure of the data.

5. Use AddDataTableEntries service of the DataTable to add the records to the DataTable.

I hope it helps.