Help Desk

Submit a ticket My Tickets
Welcome
Login

Smart Filters

In this exercise, we will fetch data from a URL using the HTTP BizApp and then configure a OneCloud Smart Filter.

Step 1: Fetch Sample Data

  1. Create a new Chain and name it "Smart Filters - Text" (Learn more).
  2. Add the first Command and select HTTP -> GET operation.

    (Hint: use the Find tool to search for "HTTP" and then search for "GET".)

  3. Edit the "GET" Command with the following settings:

    ParameterSetting
    Command NameGet Fact Data
    URLSet to the Workspace variable "fact-data"
    File NameResponse from the "Get Fact Data" Command Output
  4. Save the Command.

Step 2: Add A Command to Preview the Data

  1. Select the File Utilities -> List File Content Command.

    (Hint: use the Find tool to search for "File Utilities" and then search for "List File Content")

  2. Connect the "Get Fact Data" Command to the "List File Content" Command.

  3. Edit the "List File Content" Command with the following settings:

    ParameterSetting
    Command NamePreview Data
    Preview Lines10
    File NameResponse from the "Get Fact Data" Command Output
  4. Save the Command.

Step 3: Add A Smart Filter

In this step, we will isolate only records that contain “Mass” and “Budget” 

  1. Select the Tabular Transformation -> Smart Filters Command.
    (Hint: use the Find tool to search for "Tabular Transformation" and then search for "Smart Filters")
  2. Connect the "Get Fact Data" Command to the "Smart Filters" Command. 
  3. Edit the "Smart Filters" Command with the following settings:
    ParameterSetting
    Command NameSmart Filter Rows
    Input FileResponse from the "Get Fact Data" Command Output
    First operator for the primary filter
    AND
    Text FilterAND
    Use the ADD button to create your first filter with the following settings
    a) Set the Column Name to "MARKET" (all caps)
    b) Set the Condition to Contains
    c) Set the Compare Text to "Mass"
    Add a second filter by using the ADD button with the following settings
    a) Set the Column Name to "SCENARIO" (all caps)
    b) Set the Condition to Equals
    c) Set Compare Text to "Budget"
    Preview ResultsEnabled
    Inverse OptionEnabled
  4. Save the Command.

Step 4: Publish and Run the Chain

Before the Chain can be run, it needs to be published. After the Chain is published, it can be run.

  1. Publish the Chain, by clicking the PUBLISH button on the upper bar.
  2. Navigate to the Execute area of OneCloud by clicking on the EXECUTE button on the upper bar.
  3. Run the Chain.
  4. During or after the run is complete, click on Smart Filter Command to see the output and confirm that the operation is working correctly with only "Massachusetts" and "Budget" records.

Step 5: Validate

Confirm that your data looks like the following: 

YEARMEASURESPRODUCTMARKETSCENARIOPKG_TYPEDATA 
JanSalesColaMassachusettsBudgetCan460
FebSalesColaMassachusettsBudgetCan440
MarSalesColaMassachusettsBudgetCan460
AprSalesColaMassachusettsBudgetCan490
MaySalesColaMassachusettsBudgetCan520
JunSalesColaMassachusettsBudgetCan610
JulSalesColaMassachusettsBudgetCan630
AugSalesColaMassachusettsBudgetCan630
SepSalesColaMassachusettsBudgetCan540


What's Next?

> Advanced Tabular Transformation

B
Brian is the author of this solution article.

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.