Data Mapping cfxdm - dm:recall

Recall or retrieve the data from saved named dataset

dm:recall: This cfxdm function allows the user to recall or retrieve the data from a saved (named) dataset.

dm:recall syntax:

• name (mandatory): Name of the dataset to recall - name = '<named-dataset-name>'

• cache (optional): Cache the result for future recalls. 'yes' or 'no' - cache = '<yes or no>' (default is 'no').

• cache_refresh_seconds (optional): cache_refresh_seconds = '<seconds>' (default 120 seconds). Refresh the cache (if new update available) after specified seconds

• return_empty (optional): Return an empty dataframe if an error occurs loading the dataset - return_empty = '<yes or no>' (default is 'no').

• empty_df_columns (optional): Comma separated list of columns for empty dataframe.

Use dm:savedlist tag to list saved datasets

Example 1:

Default dm: recall functionality is captured in this example.

This section explains how users can use a CSV file loaded into a dataset. This saved dataset will be used to explain how the dm: head function can be used to check the head of the stored dataset.

Download the incidents.csv file to the local machine as shown below using a standard web browser.

Example 1:

Default dm: save functionality is captured in this example.

Step 1: Download 'incidents.csv' to the AIOps RDA environment as shown below from the local file system.

Downloaded file on local filesystem

Step 2: Upload the file 'incidents.csv' to AIOps studio using file-browser (as shown below)

Screenshot displays how to upload a file into AIOps Studio.

Step 3: Add a new empty pipeline with the name "dm_recall_example_1" as shown below and click the "Save" button (this step will create an empty pipeline and saves it to AIOps studio).

Empty pipeline

Step 4: Add the following pipeline commands into the empty pipeline text field that you have created in above Step 3.

You can copy the below code into your pipeline and execute that in your environment. ##### This pipeline loads incidents.csv file into AIOps Studio. ##### AIOps studio stores the data loaded from incidents.csv file ##### into local dataset named 'incident-summary'. ###### Pipeline uses saved list as well as recall functions to print the saved dataset ###### output @files:loadfile filename = "incidents.csv" --> @dm:save name = 'incidents-summary' --> @c:new-block --> *dm:savedlist --> @dm:recall name = 'incidents-summary'

Pipeline coded added to empty pipeline.

Step 5: Click verify button to verify the pipeline. RDA will verify the pipeline without any errors (as shown below)

Step 5: Click execute button to execute the pipeline. RDA will execute the pipeline without any errors (as shown below)

RDA executes pipeline without any errors

Step 6: Verify that the incidents-summary dataset is part of the dm: savedlist and dm:recall call as shown in the below screenshot.