- Mark as New
- Follow
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report
Hi,
Repeat insert statements for each of your cols:
- insert into new_eav_table (ID, AttributeName, AttributeValue)
select ID, 'FirstName', FirstName from old_table - insert into new_eav_table (ID, AttributeName, AttributeValue)
select ID, 'LastName', LastName from old_table - insert into new_eav_table (ID, AttributeName, AttributeValue)
select ID, 'Email', Email from old_table
You can also do this with select->update->update->update in a workflow.
Thanks,
-Jon
Views
Replies
0 Likes
Total Likes