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