Like what you see? Have a play with our trial version.

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. While in the Data Transformation module, configure an input step that contains the geographical data that you require.
    Note: Ensure that fields with latitude and longitude coordinates are included.



  2. Next, drag a Calculated Field step from the Transformation Step list, and connect the input (or any other previous step you may have included) to it.




  3. Bring up the this steps configurable details in the Transformation Flow panel, by clicking on the step. Click Add Item. 



  4. The calculated field popup will appear. 

  5. Create a new field by providing the GeoPoint formula: POINT(Latitude Longitude). Simply use the calculated fields to generate this formula, using the plus (+) operator to concatenate each value. The steps below will help with this:

    1. Enter POINT( in the text field. Then click Add. 



    2. Click the + (plus) button. 

    3. Using the Select Field drop down list, select Latitude

    4. Click + again.

      Image Added

    5. Include a space in the text field, and click the Add button again.

    6. Press the + button.

    7. Select the Longitude field from the drop down list.

    8. Enter the closing parenthesis in the text field, and click before using the Add button. 

  6. Click on the Validate button to confirm the validity of this formula. 



  7. If validated, click Save. You will exit the popup.

  8. The newly created calculated field column in the data preview panel will display the GeoPoint value. 



    Tip

    Rename this new column to GeoPoint.

     

     

...