You can do all in one query; you just need to add an extra row_number column with the extra partition by criteria and then add an extra self join. This...

I would add a rownumber column to the dataflow pipeline and then use a conditional split to send the rows to the destination where rownumber>6....