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.
Discussion posts and replies are publicly visible
Can you inform on how do you need the single value exactly. The expected output format will help in better suggestion for the solution
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?
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))