Skip to main content
S
siddagangus0001
September 22, 2023
Question

Aggregation

  • September 22, 2023
  • 4 replies
  • 0 views

Hi All, 

I have multiple values like this, I need to show single data ,How Can I show single value using expression rule, Is there any way to do ?

Please help on this on priority.

    4 replies

    H
    harshitham3563
    September 22, 2023

    Hello, If you want to display duplicate values you can use Union() function while displaying it. 

    https://docs.appian.com/suite/help/23.3/fnc_set_union.html

    If you want to display multiple values single time you can Union function and then use loop to display the list a!richTextBulletedList() for display purpose.

    harshas2775
    harshas2775
    September 22, 2023

    Can you inform on how do you need the single value exactly. The expected output format will help in better suggestion for the solution

    S
    siddagangus0001Author
    September 22, 2023

    There are multiple values which are repeating like in the screenshot 

    NAME.1 OF 117664 NAME.2 OF117664; NAME.1 OF 117664 NAME.2 OF 117664 like that some values are repeating, I need to show single values instead of multiple, How can we control that using aggregate fun?

    harshas2775
    harshas2775
    September 22, 2023

    You will need to use Union() function. If the data you have is already in array format then just pass the same array to function as union(array,array) and this will return the unique values only from that array. 
    If, your variable is not an array I suggest you use split with semi colons operator to convert data into array and then pass that into the union function. 

    make use of functions to convert to desired output as needed. 

    a!localvariables(
  local!names:"Data Data;Data Data;Data 2 Data",
local!nameArray:split(local!names,";"),
union(local!nameArray,local!nameArray))

    Terms & ConditionsAccessibility statement