Seddryck / NBi

NBi is a testing framework (add-on to NUnit) for Business Intelligence and Data Access. The main goal of this framework is to let users create tests with a declarative approach based on an Xml syntax. By the means of NBi, you don't need to develop C# or Java code to specify your tests! Either, you don't need Visual Studio or Eclipse to compile your test suite. Just create an Xml file and let the framework interpret it and play your tests. The framework is designed as an add-on of NUnit but with the possibility to port it easily to other testing frameworks.
http://www.nbi.io
Apache License 2.0
107 stars 37 forks source link

Support of new reshaping alteration "melt" #679

Open Seddryck opened 2 years ago

Seddryck commented 2 years ago

This alteration is useful to reshape a result-set into a format where one or more columns are identifier variables, while all other columns, considered measured variables, are “unpivoted” to the row axis, leaving just two non-identifier columns, ‘variable’ and ‘value’.

Attributes:

Elements:

Original table

Fruit Price Stock
Apple 10 125
Peer 22 145
Orange 5 15

Alteration

<melt variable-identifier="[attrib.]">
   <keys>
      <column identifier="#0">
   </keys>
<melt />

Result table

Fruit attrib. value
Apple Price 10
Apple Qty 125
Peer Price 22
Peer Qty 145
Orange Price 5
Orange Qty 15