Data Mapping cfxdm - dm:recall
Recall or retrieve the data from saved named dataset
Last updated
Recall or retrieve the data from saved named dataset
Last updated
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 tag to list saved datasets
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.
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.
Step 2: Upload the file 'incidents.csv' to AIOps studio using file-browser (as shown below)
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).
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'
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)
Step 6: Verify that the incidents-summary dataset is part of the dm: savedlist and dm:recall call as shown in the below screenshot.
