- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
primary key in dynamic schema
hi,
in excel file there are 5 columns in that center one(3rd column) is my primary key.
if i want to send the datas to DATABASE using dynamic schema, how can i do this
note: the position of primary key should not be changed , it should be at center
i can able to do this job with primary key at last position and first position, but i want to know how to do this when my primary key at the center position

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
You just have to tick the key checkbox for which so ever you want to specify as a primary key even though if it is dynamic schema, refer the pic .You can keep the previous one too i.e rollno, and it reflects at the same position only.
solu2.png
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
hi
thanks for the reply, but here, in your image all the column are in different datatypes like int, string but i want the left side of the tmap have one column and it should be of dynamic type
