Remove duplicate values in grid

Question

Hi All, 
 
 I have requirement where I need to remove consequent duplicate value while showing the data in grid. 
 i,e if values are: {"Requested", "Requested", "Pending","Sent For Approval","Approved","Pending","Approved","Approved"} the expected output is {"Requested", , "Pending","Sent For Approval","Approved","Pending","Approved"} 
 Here "Requested" and "Approved" are getting rejected as they are consequently occurring twice.

Madhusudan Sharma · Accepted Answer

Try this: 
 a!localVariables(
 local!list: {
 "Requested",
 "Requested",
 "Pending",
 "Sent For Approval",
 "Approved",
 "Pending",
 "Approved",
 "Approved"
 },
 local!newList: reject(
 fn!isnull,
 a!forEach(
 items: local!list,
 expression: if(
 or(
 fv!index = 1,
 local!list[fv!index - 1] <> fv!item
 ),
 fv!item,
 null
 )
 )
 ),
 local!newList
) 
 Hope it helps.

Mike Schmitt · Answer

Pretty sure a!forEach() can handle this implicitly, without needing to involve legacy looping functions or helper rules. E.G.: a!localVariables(
 local!values: {"Requested", "Requested", "Pending", "Sent For Approval", "Approved", "Pending", "Approved", "Approved"},
 
 a!forEach(
 local!values,
 if(
 fv!isFirst,
 fv!item,
 if(
 fv!item = local!values[fv!index - 1],
 {},
 fv!item
 )
 )
 )
) 
 Result: 
 Note that this would collapse *all* consecutively repeated values, not just cases where there are 2 repeated items. Though it sounds like this satisfies OP's use case anyway.

GauravSingh · Answer

Thanks Mike, 
 This really helped with small variation as I was using one cdt where two fields needs to be considered together. 
 a!localVariables(
local!RequestHistory:###Query From DB###,
local!uniqueHistoryData:a!forEach(
 local!colocationRequestHistory,
 if(
 fv!isFirst,
 fv!item,
 if(
 and(
 fv!item.statusExternal = local!RequestHistory.statusExternal[fv!index - 1],
 fv!item.stage = local!RequestHistory.stage[fv!index - 1],
 ),
 {},
 fv!item
 )
 )
 ),
 local!uniqueHistoryData
 )

Remove duplicate values in grid

Top Replies