Skip to main content
Implemented

ODX to DW Individual Field additions to existing table

  • December 9, 2020
  • 3 replies
  • 4 views

Forum|alt.badge.img

When dragging a table from the ODX to a DW using the secondary mouse button, we are able to use a field selection dialogue to choose the specific fields we would like to add to the new DW table.

However, if I have an existing table, there is not an easy way to add just one or two fields as needed.  Instead I have to synchronize the ODX table to the DW table, which will add all the remaining fields.  Then, I need to delete the extra fields which are not needed.  In some cases, this could be 150+ fields!

Ideally, I'd LOVE to see the traditional Data Selection pane being used here.  That is an outstanding feature which is sorely missed in ODX projects.  Especially the ability to preview the data and select fields right from that preview.  I understand that doesn't really fit with how the ODX functions, but the ability to select individual fields to add to an existing table is a must have.

3 replies

Forum|alt.badge.img
  • Community Manager
  • December 14, 2020

Hi David

I am not sure I understand the issue.

If you drag in a new table, to map more than one, you have the option to only map existing tables or smart synchronize.
L9x7vstDMVRer1mxfyPFBA.png

As always, the option shown in bold is what happens when you use the left click drag method.

If you then want to add new fields or map fields you can do so afterwards by dragging them in from the Data Movement view.
NNE0itXNEi6uyAImUqTJCg.png


Forum|alt.badge.img
  • Author
  • Known Participant
  • December 14, 2020

You're correct Thomas.  I was trying to bring the table in from the ODX Select Data window and didn't notice that the Data Movement pane is there for ODX to DW mappings.

I am able to add individual fields from the ODX source without a problem via Data Movement

Thank you for pointing me in the right direction!


Forum|alt.badge.img
  • Community Manager
  • December 14, 2020

You are welcome.

 

Regards

Thomas Lind