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

Error rendering macro 'rw-search'

null

Versions Compared

Key

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

...

These details will enable you to configure this step with ease.

 

Input Options

 

  • Basic configuration: Use this setting if the entire address is provided as a single column.

  • Advanced configuration: Switch to the advanced setting mode if individual parts of an address are specified. Any fields that are left blank, or values that are null will be ignored. As this is more specific it will tend to produce better results than the full address version.

    Tip

    You can also concatenate a split up address together by using the Calculated Field step, and stringing each field with a plus (+) operator.

  • API Key: OpenCage provides an API key which is necessary to run the geocoding step. To obtain this key, see: https://geocoder.opencagedata.com/ 

  • Preview Mode Row Limit: The API key has a usage limit to the number of times you can use the API, depending on your pricing package. These can be consumed quickly, while testing, and once the limit is exhausted, you will not be able to use this step. To ensure that you do not use up your limits during testing, this field can be used to specify the number of times you could use the key in a preview run. If this value is set to 0, then no limit will be applied. The number you specify here will affect the number of rows in the data preview panel. Note, however, that this setting will not be applied when the flow is published and run.

...

  1. Navigate to the data transformation module. (Create button > Transformation Flow)

  2. Access the input steps list and use a step to import data into the flow. 



  3. Ensure that your data contains address values that you wish to convert to geopoints. Our example shows address values stored in different fields.



  4. Once you are ready to use the OpenCage GeoCode step, open the transformation steps panel, and drag the step into your flow. 



  5. Connect the previous step to this one. 

  6. Click on this step to bring up its configuration details in the Transformation Flow panel. (Click here if you would like an overview of some of the step configuration details.)



  7. You have two options to configure the address, as discussed below:

    1. Basic configuration: Through this default mode, you can include a full address contained in a single field. Choose this field from the Full Address dropdown. 



    2. Advanced configuration: If your address is divided amongst various fields, then use this mode:

      1. Enable the Advanced Configuration toggle. This will reveal additional setting options. 



      2. Select the various address values for their corresponding fields.

  8. Enter the OpenCage API key. Note: Yellowfin will save this key as an encrypted value.

  9. Enter a limit to control the number of times the key will be used when executing the flow in the preview mode. This will control the number of rows that are processed, since a one request is used for each row.

  10. Once you have provided all the configuration details, click Apply. 



  11. Once successful, the step will generate a new column called LongLat, displaying the converted geopoints. This is the default column name of this output. You can always rename it. 



  12. You can continue transforming your data by adding more steps, or save the result by using an output step.

...