Transpose

configuration-examples Transpose

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
   );