The pivoting node does not include missing values. In addition, unchecking missing, the node doesn’t save that but actually keeps missing checked. Tested with several aggregation methods.
Attached a workflow to demonstrate that there should be 62.097 Rows but after pivoting it’s significant less as the column “RowID” which got missing values are not present. Splitting rows double verifies the issue.
190130 Pivoting Missing ingnored.knwf (16.4 KB)
Sample_data.csv.gz.zip (281.7 KB)
