批量操作

xiaoni · 发表于 2023-10-5 13:53

选择.zip (14.03 KB, 下载次数: 16) ，我只要Accumulate第一参数的行，为什么只保留了一行呢

minchar · 发表于 2023-10-5 17:07

你这叫猴子劈棒子，只留最后个！应该有累加计算
= List.Accumulate({"甲","丁","张三","辛","壬"},#table({"姓名"},{}),(x,y)=>x&Table.SelectRows(更改的类型,each [姓名]=y))

quqiyuan · 发表于 2023-10-5 19:49

又或者我这个：= Table.FromRows(List.Accumulate({"甲","丁","张三","辛","壬"},{},(x,y)=>x&Table.ToRows(Table.SelectRows(更改的类型,each [姓名]=y))),Table.ColumnNames(更改的类型))

尘土1 · 发表于 2023-10-7 11:17

= Table.SelectRows(更改的类型,each List.Contains( {"甲","丁","张三","辛","壬"},[姓名]))

hbzql · 发表于 2023-10-9 17:57

= List.Accumulate({"甲","丁","张三","辛","壬"},#table({},{}),(x,y)=>x&Table.SelectRows(更改的类型,each [姓名]=y))

一江春水1688 · 发表于 2023-10-14 23:17

一江春水1688 · 发表于 2023-10-14 23:19

明明在电脑，转手机页面了？再贴一次：
= Table.FromList(List.Intersect({更改的类型[姓名],{"甲","丁","张三","壬","辛"}}),null,{"姓名"})

		自动登录	找回密码
密码			免费注册

[求助] 批量操作