Currency Conversion

This guide explains how to use the Currency Conversion enrichment to convert currency-based metrics in your data table from one currency to another.

Introduction

Converting currency-based metrics in your data table from one currency to another is a way to enrich your data.

The Currency Conversion enrichment uses the currency custom script in the background. The Currency Conversion enrichment provides a user-friendly interface that helps you find which column contains the currency to convert and the currencies to convert between.

Concept

Enriching your data means transforming and tailoring the data according to your needs. An enrichment is a set of instructions that you specify for Adverity to transform your data.

When you create an enrichment, you add it to the list of available enrichments in the workspace.

When you assign an enrichment to a datastream, each time data is fetched for the datastream, the data is transformed according to the enrichment. The enrichment only has an effect on datastreams to which you assign the enrichment.

Prerequisites

Before you complete the procedure in this guide, perform all of the following actions:

• Create a datastream. For more information, see Introduction to collecting data.

• Apply the correct Data Mapping for your datastream. For more information, see Introduction to harmonizing data.

• Make sure that the data table fetched from the datastream contains a field with a metric in the source currency that you want to convert to the target currency.

• If you have multiple currencies in the data extract, ensure the data extract contains a column with information about the currencies in the ISO format.

Converting currency data

To convert values in a column of your data table from one currency to another, follow these steps:

1. Select the workspace you work with in Adverity and then, in the platform navigation menu, click Enrichments.

2. In the top right corner, click + Create Enrichment.

3. Click Currency Conversion.

4. (Optional) To assign the enrichment to individual datastreams of your choice, follow these steps:

   1. In the Assign to section, select Individual datastreams.

   2. In the drop-down menu, select the datastreams to assign the enrichment to them.

5. (Optional) To assign the enrichment to all existing and new datastreams that belong to Datastream Types of your choice, follow these steps:

   1. In the Assign to section, select Datastreams Types.

   2. In the drop-down menu, select the Datastream Types to assign the enrichment to all datastreams that belong to these types.

   3. (Optional) In the Do not assign to these individual datastreams drop-down menu, select the individual datastreams that belong to the Datastream Types that you have selected, but you do not want to assign the enrichment to them.

6. Click Next.

7. Under the Instructions tab, in the Source column drop-down menu, select the field that contains values in the source currency.

8. In the Exchange rate provider drop-down menu, select an organization from which to use an exchange rate.

9. In the From currency drop-down menu, select the source currency. If you have multiple currencies in a column in the data extract, select Automatic. This list of available currencies changes based on the organization selected in the Exchange rate provider field.

   • For the list of currencies supported by Open Exchange Rates, see the Open Exchange Rates documentation.

   • For the list of currencies supported by the European Central Bank, see the European Central Bank documentation.

10. If you selected Automatic in From currency, select the column that contains information about currencies in Currency column.

11. In the To currency drop-down menu, select the target currency.

12. In the Date column drop-down menu, select the field in your data table that contains the dates associated with the currency-based metric.

13. (Optional) By default, Adverity replaces the existing values in the field that contained the values text in the source currency. To preserve the original field and add the converted values to a new field, select Add additional column in the Action drop-down menu.

14. (Optional) Click the Table Preview tab to display the impact of the instructions on the data extract. For more information, see Previewing enrichments.

15. Click Next.

16. (Optional) In Enrichment name, rename the enrichment.

17. Click Create +.