分组后对齐再转置
【问题】
I’m sorry….power outage….
So, this is my data:
userid type descr
scooby dog dog
scooby hair long
scooby weight 50
mickey mouse mouse
mickey hair (blank)
……
I need to build a report that have rows and column that have:
userid type hair weight
scooby dog long 50
mickey mouse null 2
【回答】
这是变换过的转置操作，用 SPL 实现较为方便：
| A | |
|---|---|
| 1 | =connect(“demo”) |
| 2 | =A1.query(“SELECT *FROM tb2”) |
| 3 | =A2.group(USERID).new(USERID,(t=~.align@s([“hair”,“weight”],TYPE).(DESCR))(3):type,t(1):hair,t(2):weight) |
A2 中的数据：
A3 运行结果：
A1：连接数据库
A2：查询数据
A3：分组对齐后转置
