大佬们帮我看看我发的2个案例如何实现，谢谢啦。

cnmlgb9998

coole235 发表于 2024-4-16 10:34
PQ怎么操作？

分组 即可

zpy2

//select * from 基础转二维 limit 20;
cli_create_two_dim~基础转二维~品牌名称~品牌号码;
select * from 基础转二维_two_dim;

zpy2

zpy2 发表于 2024-4-16 11:50
//select * from 基础转二维 limit 20;
cli_create_two_dim~基础转二维~品牌名称~品牌号码;
select * fro ...

create temp table aa as
select upper(品牌名称) 品牌名称,图纸号,group_concat(品牌号码,'/') 品牌号码 from 基础转二维 group by upper(品牌名称),图纸号;
select * from aa;
cli_create_two_dim~aa~品牌名称~品牌号码;
select * from aa_two_dim;

品牌大写

一杯绿茶来了

=LET(p,LET(a,TOCOL(UNIQUE(A2:A21)&"/"&TRANSPOSE(UNIQUE(C2:C21))),DROP(REDUCE("",a,LAMBDA(x,y,VSTACK(x,LET(m,TEXTBEFORE(y,"/"),n,TEXTAFTER(y,"/"),z,TEXTJOIN("/",,FILTER(B2:B21,(A2:A21&"/"&C2:C21)=y,"")),HSTACK(m,z,n))))),1)),VSTACK({"图纸号","品牌号码","品牌名称"},FILTER(p,CHOOSECOLS(p,2)<>"")))

=LET(a,TOROW(UNIQUE(C2:C21)),b,UNIQUE(A2:A21),j,DROP(REDUCE("",b,LAMBDA(x,y,VSTACK(x,HSTACK(y,DROP(REDUCE("",a,LAMBDA(m,n,HSTACK(m,TEXTJOIN("/",,FILTER(B2:B21,A2:A21&C2:C21=y&n,""))))),,1))))),1),VSTACK(HSTACK(A1,a),j))