Fixed
Last updated
Last updated
Returns a fixed value specified by the 'value' parameter. @param value Type can be string or number
This function is helpful when a user wants to get a fixed value from a dataset (or set of column values).
Step 1: Create an empty fixed_example using AIOps studio as shown in the below screenshot.
Step 2: Add the following pipeline code/commands into the above-created pipeline as shown in the below screenshot:
You can copy the below code into your pipeline and execute that in your environment.
##### This pipeline creates a list of rows with sales amount (int values) for each month
##### using AIOps studio.
##### RDA function fixed is used to demo this example (along with groupby, sum)
##### TOTAL is used as a variable on which sum is performed to get the total sales
##### amount for all six months (RDA uses agg = "sum" to calculate sum of all sales
##### and provide the output of the total amount. Here TOTAL is used as an additional
##### dummy column to allow RDA to calculate the sum.
@dm:empty
--> @dm:addrow amount = 10000 & month = 'Jan'
--> @dm:addrow amount = 15000 & month = 'Feb'
--> @dm:addrow amount = 11000 & month = 'Mar'
--> @dm:addrow amount = 18000 & month = 'April'
--> @dm:addrow amount = 8000 & month = 'May'
--> @dm:addrow amount = 10000 & month = 'June'
--> @dm:map to = "TOTAL" & func = "fixed" & value = "TOTAL"
--> @dm:groupby columns = "TOTAL" & agg = "sum"
--> *dm:filter * get TOTAL, amount
Step 3: Click verify button to make sure syntax and pipeline code is correct (as shown below)
Step 4: Click execute button and execute the pipeline. RDA will execute the pipeline without any errors (as shown below)
Step 5: RDA uses the dm function 'fixed' to use a dummy column across all the available rows and provides a sum of 'amount' columns (which are defined in int') and provides an aggregate/sum value in the amount column after pipeline execution as shown in the below screenshot.
