This topic discusses application of the **Transform Dialog** with **Tables**
on a **numeric** field in a table.
See the **Transform
Dialog** and **Transform
Templates** topics for use and for links to lists of templates
for other data types for tables and use of the Transform Dialog with other
components, such as **Drawings**
and **Images**.

Absolute Value |
Take the absolute value of the number in the source field and put it into the target field. Absolute value leaves positive numbers unchanged and converts negative numbers into their positive equivalents.
Example: Put in |

Add |
Add the two source fields and put the result in the target field.
Example: |

Arc Cosine |
Take the arc cosine (inverse cosine) of the source field and put it into the target field.
Example: Put in |

Arc Sine |
Take the arc sine (inverse sine) of the source field and put it into the target field.
Example: Put in |

Arc Tangent |
Take the arc tangent (inverse tangent) of the source field and put it into the target field.
Example: Put in |

Arc Tangent of Ratio |
Take the arc tangent (inverse tangent) of the ratio between the DY field and the DX field and put into the target field.
Example: Put in |

Area |
Given a |

Base 10 Logarithm |
Put the base 10 logarithm (also called the common logarithm) of the source field into the target field.
Example: Put in |

Base 2 Logarithm |
Put the base 2 logarithm (also called the binary logarithm) of the source field into the target field.
Example: Put in |

Bessel J0 |
A Bessel function of the first kind: Put the result of the Bessel function J0(x) using the source field as x into the target.
Example: Put in |

Bessel J1 |
A Bessel function of the first kind: Put the result of the Bessel function J1(x) using the source field as x into the target.
Example: Put in |

Bessel Jn |
The
Example: Put in |

Bessel Y0 |
A Bessel function of the second kind: Put the result of the Bessel Function Y0(x) using the source field as x into the target.
Example: Put in |

Bessel Y1 |
A Bessel function of the second kind: Put the result of the Bessel Function Y1(x) using the source field as x into the target.
Example: Put in |

Bessel Yn |
The
Example: Put in |

Binary And |
Perform
Example: Put in Because the binary function operates on each bit in the |

Binary Not |
Performs
Example: Put in Inverting all binary bits for the |

Binary Or |
Performs
Example: Put in The binary representation of |

Binary Xor |
Performs
Example: Put in The Boolean XOR function generates a FALSE when both inputs
are TRUE. The result in a bitwise comparison is a
FALSE, or |

Ceiling |
Put the rounded up integer value of the source field into the target field.
Example: Put in |

Ceiling up to Decimals |
Put the value of the source field rounded up to the specified number of Decimal positions into the target field.
Example: Put in |

Compare Order |
Compare the source field to the comparison field and put a 1, 0, or -1 into the target field, with 1 if the source is greater than the comparison, 0 if the same and -1 if the source is less than the comparison.
Example: Example: |

Complementary Error Function |
Take the complementary error function (also called
erfc(
Example: Put in |

Copy |
Copy the source field into the target field.
Example: Copy |

Cosine |
Take the cosine of the source field and put it into the target field.
Example: Put in |

Cube Root |
Take the cube root of the source field and put it into the target field.
Example: Put in |

Date Day |
Copy the day part
of a
Example: Put in |

Date Hour |
Copy the hour part of a datetime source field as a number into the target field.
Example: Put in |

Date Millisecond |
Copy the millisecond part of a datetime source field as a number into the target field.
Example: Put in |

Date Minute |
Copy the minute part of a datetime source field as a number into the target field.
Example: Put in |

Date Month |
Copy the month part of a datetime source field as a number into the target field.
Example: Put in |

Date Second |
Copy the seconds part of a datetime source field as a number into the target field.
Example: Put in |

Date Year |
Copy the year part of a datetime source field as a number into the target field.
Example: Put in |

Distance |
Given two |

Divide |
Divide the source field by the divide field and put the result into the target field.
Example: |

Divide and Truncate |
Divide the source field by the divide field and put the integer part of the result into the target field.
Example: |

Error Function |
Take the error function (also called erf(
Example: Put in |

Exponent |
The exponential function: Take
Example: Put in |

Floor |
Put the rounded down integer value of the source field into the target field.
Example: Put in |

Floor down to Decimals |
Put the value of the source field rounded up to the specified number of Decimal positions into the target field.
Example: Put in |

Fractional Part |
Take only the decimal fraction portion of the source and put into the target field.
Example: Put in |

Fractional Part from Decimals |
Take only the decimal fraction portion of the source beyond the specified number of Decimal positions and put into the target field.
Example: Put in |

Gamma Function |
Put the gamma function for the source field into the target field.
Example: Put in |

Hyperbolic Arc Cosine |
Put the hyperbolic arc cosine of the source field into the target field.
Example: Put in |

Hyperbolic Arc Sine |
Put the hyperbolic arc sine of the source field into the target field.
Example: Put in |

Hyperbolic Arc Tangent |
Put the hyperbolic arc tangent of the source field into the target field.
Example: Put in |

Hyperbolic Cosine |
Put the hyperbolic cosine of the source field into the target field.
Example: Put in |

Hyperbolic Sine |
Put the hyperbolic sine of the source field into the target field.
Example: Put in |

Hyperbolic Tangent |
Put the hyperbolic tangent of the source field into the target field.
Example: Put in |

Hypotenuse |
The great and ancient Pythagorean theorem: The square root of the sum of the squares of the two sides of a right triangle. Save into the target the value of the hypotenuse taking two given source fields as DX and DY.
Example: Put in Example: Put in |

JSON Number |
A means to extract
numbers that are embedded into JSON strings as the numeric value
for a named JSON entity. Scan the source field to find the
specified
Example: Find the Example: Find the The example table above has a field called
{ "Name": "Argentina Campo Inchauspe Faja 3", "System": "Transverse Mercator", "CenterLat": -90, "CenterLon": -66, "FalseEasting": 3500000, "Axes": "XYH", "Base": "Campo Inchauspe (Argentina)", "MajorAxis": 6378388, "Eccentricity": 0.08199188997902977, "Transform": "Molodensky-Badekas", "CenterX": -148, "CenterY": 136, "CenterZ": 90, "Unit": "Meter", "UnitScale": 1, "UnitShort": "m" }
Some of the named entities have numeric values and some have
string values. Using the |

Length |
Given a |

Log-gamma Function |
The log-gamma function takes the natural logarithm of the gamma function for the source field and stores the result into the target field.
Example: Put in |

Logarithm |
Put the base e logarithm (also called the natural logarithm) of the source field into the target field.
Example: Put in |

Maximum Value |
Take the maximum, that is the greater value, of either the source field or the comparison field and save into the target field.
Example: Put in |

Minimum Value |
Take the minimum, that is the lesser value, of either the source field or the comparison field and save into the target field.
Example: Put in |

Modulo |
The remainder (of
a congruence)
function: Take what is left over by the integral division of the
source field by the given
Example: Put in In the above we can see that |

Multiply |
Multiply the two source fields and place the result into the target field.
Example: |

Negate |
Multiply the source
field by
Example: |

Number of Branches |
Given a |

Number of Characters |
Count the number of characters in a source text field and put the result into the (numeric) target field.
Example: Count the |

Number of Coordinates |
Given a |

Number of Regexp Matches |
Given a text source
field, count the number of times the given regular expression
The regular expression
Example: Put into The example counts the number of occurrences of the letter |

Power |
Compute the source
field to the power of the specified
Example: Take the |

Power of 10 |
Compute
Example: Put in |

Power of 2 |
Compute
Example: Put in |

Reciprocal Cube Root |
Also known as the inverse cube root: Take 1 divided by the cube root of the source field and put the result into the target field.
Example: Put in |

Reciprocal Square Root |
Also known as the inverse square root: Take 1 divided by the square root of the source field and put the result into the target field.
Example: Put in |

Regexp Match Position |
Given a text source
field, determine the first character position within the text
that the given regular expression
The regular expression
Example: Put into The regexp pattern |

Regexp Match Position, Nth |
Given a text source
field and a regular expression
Given a string value of
Example: Put into The regexp pattern of |

Round |
Round a source field with a fractional part up or down to the nearest integer and put the result into the target field.
Example: |

Round to Decimals |
Round a source
field with a fractional part up or down to the number of decimals
specified by
Example: |

Sign |
For a source field
that is positive or negative put a
Example: Determine |

Sine |
Take the sine of the source field and put it into the target field.
Example: Put in |

Size in Bytes |
Take the size in
bytes of the value in the source field and put into the target
field. This will be the same number for numeric source fields
(for example,
Example: Put in |

Square Root |
Take the square root of the source field and put it into the target field.
Example: Put in |

Subtract |
Subtract one source field from the other and put the result into the target field.
Example: |

Tangent |
Take the tangent of the source field and put it into the target field.
Example: Put in |

Text Compare Order, Intl |
Compare text sort
order of source field and comparison field. If the source field
comes in a
Example: Put in In the first record a text value beginning with |

Text Position |
Find the specified
string in the text source field and count the character position
number (beginning at
Example: Put in Only one match occurs above, in the third record where |

Text Position, Intl |
Same as |

Text Position, Nth |
Given a text source
field, a
Given a string value of
Example: Put in The string |

Truncate |
Take the integer part of the source field, discarding any decimal fraction part, and put the result into the target field.
Example: |

Truncate to Decimals |
Take the integer
part of the source field as well as any decimal fraction up to
the specified number of
Example: |

Vector Value |
Copy the specified
part of a vector numeric
Example: Put in Example: Put in Example: Put in |

**Everything Math** - For a handy
reference to anything in mathematics, see the Wolfram
MathWorld site. Thank you, Wolfram!

A guy walks into a bar and asks for **1.014**
root beers. The bartender says, “I’ll have to charge you extra,
that’s a root beer **float**”. So
the guy says, “In that case, better make it a **double**.”

Why do programmers confuse Halloween with Christmas? Because OCT 31 = DEC 25.

Transform Templates - Drawings

Transform Templates - Datetime

Transform: Center and Centroids

**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.