Icon

extract missing numbers from column

input dataidentify minmax valuein input datacreate columnwith data rangebased on mix max valueiteration column +1collect resultsmissing_numbersmissing_numberscreate group_idcreate group_idgroup_idExcel Reader GroupBy Table Rowto Variable Counting Loop Start Math Formula Loop End Column Filter Joiner Rule Engine Lag Column Rule Engine Missing Value GroupBy input dataidentify minmax valuein input datacreate columnwith data rangebased on mix max valueiteration column +1collect resultsmissing_numbersmissing_numberscreate group_idcreate group_idgroup_idExcel Reader GroupBy Table Rowto Variable Counting Loop Start Math Formula Loop End Column Filter Joiner Rule Engine Lag Column Rule Engine Missing Value GroupBy

Nodes

Extensions

Links