On several occasions I've found myself wishing this feature existed but never got around to requesting it. When importing data from a flat file (CSV in my case) into a database table I have had several occasions where the database table has an identity column (SQL Server) but the flat file does not. When the second import screen pops up you can alter the position where each of the flat file fields get imported into. So, in my case, I just shift each one by 1. In other words, the first field which shows Position 1, I remove that position and then start with Position 1 from the second field. The import works flawlessly doing this but it is a hassle when you have a large number of columns and have to change the numbering on each one by one. I would love to see a feature to "renumber" or "shift" the fields in bulk. I envision this as either a right click function when clicking on the position cell or the position header but leave the design up to you :)
If there is already a way to do this that I'm not aware of, please advise.
If there is already a way to do this that I'm not aware of, please advise.
Currently, you cannot do this without having to renumber the columns individually.
We'll give this some thought and see if we can come up with a UI to support this request.
Kin-Hong, lets discuss possible options next week
Kin-Hong, lets discuss possible options next week
On the "Format" tab, two popup menu items now show up for the "File Column" and "Position" columns of the "Table Column Info" table. They are:
On the "Format" tab, two popup menu items now show up for the "File Column" and "Position" columns of the "Table Column Info" table. They are:
Great! Look forward to seeing it in a future build
Great! Look forward to seeing it in a future build
One thing to note is that, users need to right click on File Column or Position for the menu to pop up and make the selection. Verified in ADS 13.0.0-3 and works fine.
Download Patch for v13 : http://dd1.aquafold.com/download/v13.0.0/ads-13.0.0-3-patch.zip
Patch Update Instructions: http://www.aquafold.com/support-update.html#v13
One thing to note is that, users need to right click on File Column or Position for the menu to pop up and make the selection. Verified in ADS 13.0.0-3 and works fine.
Download Patch for v13 : http://dd1.aquafold.com/download/v13.0.0/ads-13.0.0-3-patch.zip
Patch Update Instructions: http://www.aquafold.com/support-update.html#v13
Issue #8692 |
Closed |
Fixed |
Resolved |
Completion |
No due date |
No fixed build |
No time estimate |
Currently, you cannot do this without having to renumber the columns individually.
We'll give this some thought and see if we can come up with a UI to support this request.