Adding A Custom Query

Adding A Custom Query

To add a Custom Query while creating a dataset, follow the steps given below.

  1. At the product selection page click on create dataset under Data Connect.

  2. Then Select any dataset Under RDBMS
  3. Click  Add  Custom Query on selected dataset. Then Add Custom Query page is displayed.

  4. Enter a suitable Name for your custom query.
  5. Enter a suitable Description for your query.
  6. Enter your query in the Add Custom Query field. (For example, select * from A where city = "Pune")
  7. Click Add Query. The query is added to your Dataset.

The following figure shows Add Custom Query page.




Notes:

  • You can add multiple queries to your Dataset. Repeat the steps to add more custom queries.
  • For more information on MongoDB custom query, refer Query Your Data

    • Related Articles

    • Custom Functions in RubiPython

      Reading Data from File A sample Python code to read data from file is shown in the image below. The table below explains the above code snippet. Line of Code Result getReaderData(“datasetName”,“subdatasetName”) This custom function checks the type of ...

    • Custom Functions in RubiPython

      Reading Data from File A sample Python code to read data from file is shown in the image below. The table below explains the above code snippet. Line of Code Result getReaderData(“datasetName”,“subdatasetName”) This custom function checks the type of ...

    • Enable Direct Query

      To Enable Direct Query for a dataset in the dashboard, follow the steps below. Open the dashboard in edit mode. Refer to Editing the Dashboard. The dashboard is displayed. If required, add a new dataset to the dashboard. Refer to Adding a dataset to ...

    • Direct Query

      "Direct Query" is the term that usually refers to a feature in Data Visualization. It fetches the real-time data from the underlying data source. The direct query option is useful when dealing with large datasets that are unable to import efficiently ...

    • Custom Word Remover

      Custom Words Remover is located under Textual Analysis in Pre Processing, in the task pane on the left. Use drag-and-drop method to use algorithm in the canvas. Click the algorithm to view and select different properties for analysis. One of the ...