Lookup Tables

Overview
Use Cases of Lookup Tables
Uploading New Lookup Tables
       Managing Lookup Table
Using Lookup Tables
       To Transform Data

       To Filter Data

OVERVIEW

CreateUploadUse_Lookup_Tbl.png

USE CASES OF LOOKUP TABLES 

  • To transform and filter data from streams before streaming to Anodot
  • To stream  new data where the existing filters and transformations may no longer apply
  • To apply additional and updated transformations and filters to data, without creating  new streams

UPLOADING NEW LOOKUP TABLES 

  1. From the main Anodot navigation menu bar, choose Streams .
  2. In the Sources + panel, choose Lookup Tables to display the Lookup Tables+ panel.
  3. Click Lookup Tables  and click Choose file on the Upload guidelines tips.
  4. Browse to upload the new Lookup table file.
    Note: The file must be:
    - In CSV format
    - Contain only 2 columns and up to 999 rows
    - The first row must contain the column names
    - The left column must contain unique values, and is used as input to the lookup.
  5. The new Lookup Table is displayed in the Lookup Table+ panel.

Managing Lookup Tables

  1. On the Lookup Tables+ panel, highlight a table.
  2. Click the More Icon to:
    • View preview the table
    • Download download the Lookup table to your own computer.
    • Reload an Edited updated, existing  Lookup table. [The original CSV file will be overwritten]
    • Delete - Only available if the Lookup Table is not used in any stream.

USING LOOKUP TABLES 

To Transform Data

  1. Navigate to the Streams page.
  2. On the Streams page, choose the source and stream to which you want to apply a transform function.
  3. Click the More icon > Edit, to display the Stream Query page.
  4. Check that the dimension you want to transform is listed in the Measures & Dimensions panel. and click Next to display the Stream Table.
  5. Hover over and click the Dimension column you want to transform to display the Fine-Tune option.   
  6.  Click Fine-tune to open the Dimension Fine-tune dialog box.
  7.  Choose Replace by Lookup Table from the Transforms menu.
  8.  In the Transform and Filter dialog box:
    • Choose the Lookup Table you want to apply
    • Type free-text in the If not Found text box to replace existing values that do not have a corresponding input row in the Lookup table.
      Fine_tune_-transformer_db.png
  9. Click Apply. The Lookup Table replacement is automatically applied.

 To Filter Data

  1. Navigate to the Streams page.
  2. On the Streams page, choose the source and stream to which you want to apply a filter.
  3. Click the More icon > Edit, to display the Stream Query page.
  4. Check that the dimension you want to transform is listed in the Measures & Dimensions panel. and click Next to display the Stream Table.
  5. Hover over and click the Dimension column you want to filter to display the Fine-Tune option.
  6. Click Fine-tune to open the Dimension Fine-tune dialog box.
  7. Choose Filter by Lookup Table from the Transforms/Filter menu.
  8. In the Transform and Filter dialog box, choose the Lookup Table you want to apply.

Fine_tune_-_filter_db.png

9. Click Apply. The Lookup Table filter is automatically applied.

  

 

Was this article helpful?
0 out of 0 found this helpful