Example: Copy one Column into Another Column with Transform

In this example we will use the Transform dialog to copy the contents of one column in a table into another column, but only for selected records.  We will use the Products table from the Nwind example data set.   

 

eg_trnsfd01_01.png

 

Open the Products table and Ctrl-click the row handles for two records to select those records.   The Units On Order value for both of the selected records is 0.

 

eg_trnsfd01_02.png

 

 

Right click on the Units On Order column and choose Transform to open the Transform dialog.  It will appear pre-loaded with the Units On Order field already chosen as the target field.

 

eg_trnsfd01_03.png

 

We scroll down the list of available commands (all of which make sense to use with a field of type int16) and click on the Copy command.  A Value combo box appears.

 

eg_trnsfd01_04.png

 

We click the Restrict to selection box and then we choose Units In Stock in the Value box.   We are telling Manifold to copy into the Units On Order field the values from the Units In Stock field and to do that only for the selected records.  The copy command is previewed in the table by showing that the values for the Units On Order, if we commit the changes, will be changed from 0 for each field to 39 and 53 respectively.   We press the Update Field button to commit the changes.

 

eg_trnsfd01_05.png

 

The Products table now shows the new values for the Units On Order field for the selected records.

 

 

See Also

Transform Dialog

 

Transform Options

 

Command Window

 

Queries

 

Transform Templates

 

Transform Templates - Boolean

 

Transform Templates - Datetime

 

Transform Templates - Geom

 

Transform Templates - Numeric

 

Transform Templates - Text

 

Example: Two Drawings from the Same Table - Take a table with a geom field that is visualized by a drawing.  Add a second geom field to the table and create an rtree index on that field so it can be visualized by a drawing.   Copy the first drawing, paste it and adjust the pasted copy so it uses the second geom field. Demonstrate how to use the Transform dialog to show "live" modifications in the second drawing compared to the first drawing.

 

Example: Copy one Column into Another Column with Transform - How to use the Transform dialog to copy the contents of one column in a table into another column, but only for selected records.  Uses the Products table from the Nwind example data set.  

 

Example: Transform Field Values using an Expression in the Transform Dialog -  How the Expressions tab of the Transform Dialog may be used to change the values of fields.   We include an example of changing the price of selected products and using two different Transform dialogs open at the same time for two different table windows.

 

Example: Construct JSON String using Select and Transform - Use the Select and Transform dialogs to manually construct a JSON string using values from other fields in a table. Shows how we can manipulate text to build desired contents in a field.

 

Example: Edit a Drawing with Transform Dialog Templates -  In this example we open a drawing and edit objects in the drawing using the Transform dialog Template tab.   Includes examples of using the Add Component button and also the Edit Query button.

 

Example: Use a Transform Dialog Expression to Create Buffers in a Drawing - Use the Expression tab of the Transform Dialog to create three different sizes of buffers for different lines in a drawing and then automatically create a query which does the same thing.  Includes examples of using the Add Component button and also the Edit Query button.

 

Example: Clip Areas with a Transform Dialog Expression - Use the Expression tab of the Transform dialog to clip areas in a drawing to fit within horizontal bounds.   Includes examples of using the Add Component button and also the Edit Query button.

 

Example: Smooth Lines with a Transform Dialog Expression - Use the Expression tab of the Transform dialog to make lines smoother in a drawing so that longer lines are smoothed more.  Includes examples of using the Edit Query button to show how different queries are created automatically depending on if we want to update a field or to add a new component.

 

Example: Transfer Options and Merge Areas - Using the Merge Areas Transform dialog template, an exploration of the difference between using Copy and Sum for transfer options.