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

Community Tip - Your Friends List is a way to easily have access to the community members that you interact with the most! X

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

hrastogi
1-Visitor

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
12-Amethyst
(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.

Announcements


Top Tags