Convert Tree into Table columns

Community Support
1

Hi All,

I have a problem statement where I need to convert Tree kind of rows into columns.

 
For Ex:-

I have a table Tree where I have rows as follows :

Rule       | Key         | Value
Rule1      | Key1      | Val1
Rule1      | Key2      | Val2

Rule2      | Key1      | Val3

Rule2      | Key2      | Val4

Rule3      | Key1      | Val5

Rule3      | Key2      | Val6

Rule3      | Key3       | Val7

Now I want to convert the unique keys as a column to my output tree and values be the row value.

Output Table :-

Rule       | Key1         | Key2**          | Key3**
Rule1     | Val1          | Val2          | 
Rule2     | Val3          | Val4          | 

Rule3     | Val5          | Val6          |  Val7

Basically, I want to group all rules together, create columns out of all unique keys and respective values.

Not sure how to do it in kdb. Can somebody help here?

2

https://code.kx.com/q/kb/pivoting-tables/

exec distinct[t`Key]#Key!Val by rule:rule from t

3

I got the answer post posting this… We can use pivot.. Thanks to KDB…