Building the Data Experience (CinchyDXD)

Table of Contents

1. Table Creation

Create your data experience (DX) in a virtual data network.

1. Log in to Cinchy: URL: <cinchy source URL> User ID: <source user id> Password: <source password>

2. From the Homepage, select Create

3. Select Table > From Scratch

4. Create the table with the following properties (Image 1).

6. Click Columns in the left hand navigation to create the columns for the table

7. Click the “Click Here to Add” a column tab to add a column

8. Click the Save button to save your table

2. Enter Sample Data

1. In your newly created table, enter the following sample data (Image 2).

3. Create the Query

Create a simple query that pulls information from the Currency Exchange Rate table that will allow a simple currency exchange calculation.

1. From the Homepage, select Create.

2. Select Query.

3. In the query builder locate the Currency Exchange Rate table and drag it to the “FROM” line (Image 3).

4. In the “SELECT” line drag and drop the “Rate” column and enter in the following (Image 4): SELECT [Rate] * @Amount AS 'Converted Amount'

5. Enter in the following for the WHERE clause (Image 5):

WHERE [Deleted] IS NULL AND [Currency 1] = @Currency_1 AND [Currency 2] = @Currency_2

6. Click the Execute (or play) icon to run the query (Image 6):

7. Test the query by entering in the following and clicking the submit button (Image 7):

@Amount: 100 @Currency_1: CAD @Currency_2: USD

8. Save the Query by clicking on the Info tab (Left Navigation) 9. Enter in the following details for the query (Image 8):

10. Click the Save button (Image 9).