A表为关键字档案,B表为N行摘要;如何实现每行提取出含有A表的关键字并统计个数;
可以用什么方式实现
最后一个销售不算?只算物料了?不对吧
sum(MAPARRAY(SPLIT(g1,","),if(find(item,d2)>0,1,0)))
关键字提取
JOINARRAY(MAPARRAY(SPLIT(g1,","),if(find(item,d2)>0,item,"")),",")