Adding Missing Records

This workflow demonstrates how to use Pivoting/Unpivoting nodes to add missing records into data set. In case there is only one value column Pivoting/Unpivoting just does the job. In case of multiple value columns after Pivoting/Unpivoting additional nodes are needed to determine in to which value column value belongs.

This is a companion discussion topic for the original entry at