I want to import data as per tablename
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-27-2023 11:42 PM
Hello All,
I want to import data tablewise .i have list of record and their target table name is different.as per tablename i want to import data.please guide me on this.
Thank Yiu.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-27-2023 11:49 PM
Hi @--oooo-- ,
i am assuming that u dont already have transform map for that destination table. if u have then use that
- go to system import sets-->load data module
- enter table name..chose file(.xls file) make sure 1st row in excel match fields in your destination table.so it will automap.
- then click on create transform link
- give it a name,select destination table(table in which u want to upload data)
- click on auto map matching fields..if required fields do not match then click on mapping assist and match fields.
- set colesce true to any one field from related list. it will be your unique field
- click transform
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-28-2023 12:00 AM
Hello, @Community Alums, I have a list of different ci classes as per the ci class name I want to add data .how can I achieve this functionality? I know how to import data manually .please guide me on how can i import data dynamically as per the table name.
thank you.