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

Community Tip - Visit the PTCooler (the community lounge) to get to know your fellow community members and check out some of Dale's Friday Humor posts! X

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

hrastogi
1-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
ankigupta
5-Regular Member
(To:hrastogi)

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.

Top Tags