Compare and get a count of expression

Question

Hello , 
 I have two expression rules, rule 1 & rule 2. I want to compare them and print its count into grid. 
 RULE 1 
 
 ABC 
 CDE 
 GHI 
 JKL 
 
 RULE 2 
 ABC 
 DEF 
 ABC 
 DEF 
 GHI 
 ABC 
 
 I want to compare rule 1 with rule 2 and count of match records to show in grid. Like 
 
 count 
 for ABC count should be 3 and so on.

Kandarp Pandya · Answer

Hi It seems that you are using older version of Appian (As you have used a!gridTextColumn() in your modified code). 
 Please try with below code. It should work. 
 load(
 local!pagingInfo: a!pagingInfo(
 startIndex: 1,
 batchSize: 10
 ),
 local!rule1: {
 "ABC",
 "CDE",
 "GHI",
 "JKL",
 
 },
 local!rule2: {
 "ABC",
 "DEF",
 "ABC",
 "DEF",
 "GHI",
 "ABC"
 },
 local!data: a!forEach(
 items: local!rule1,
 expression: {
 value: fv!item,
 count: count(
 wherecontains(
 fv!item,
 local!rule2
 )
 )
 }
 ),
 with(
 local!dataSubSet: todatasubset(
 local!data,
 local!pagingInfo
 ),
 a!gridField(
 label: "",
 totalCount: local!dataSubSet.totalCount,
 columns: {
 a!gridTextColumn(
 label: "Value",
 data: index(
 local!dataSubSet.data,
 "value",
 {}
 )
 ),
 a!gridTextColumn(
 label: "Count",
 data: index(
 local!dataSubSet.data,
 "count",
 {}
 )
 )
 },
 value: local!pagingInfo,
 saveInto: local!pagingInfo
 )
 )
)