Transpose

Configuration examples Transpose

introduction

Transposing a table means changing the rows to columns and columns to rows.

example

container PerActor := for_each_nedv(    Classifications/Actors/name   , 'PerActorType/'+Classifications/Actors/name+'/sum'   , Classifications/WoningType   , float32  );   container PerWoningType := for_each_nedv(      Classifications/WoningType/name    , 'union_data(Classifications/Actors, '      + replace(          AsItemList('PerActor/'+Classifications/Actors/name+                            '[Classifications/WoningType/V/@WT@]')'                     ,'@WT@', Classifications/WoningType/Name)+')'     , Classifications/Actors     , float32   );