Number of rows per subgroup

On the External Data from Clipboard screen, you can specify how many rows of data will make up one subgroup.

When creating one subgroup from multiple rows, the traceability and date/time stamp applied to each subgroup will be taken from the last row in that subgroup.  If there are not enough rows to complete the last subgroup, one or more of the topmost rows in the Data from clipboard box will be ignored so that only complete subgroups will be displayed.

The following examples demonstrate how this works.

Example with one Data column

As only 5 complete subgroups of 2 could be created, the first data row in the Clipboard was ignored.  Also, the date/time stamp and Operator applied to each subgroup come from the second Clipboard row for that subgroup.

As only 3 complete subgroups of 3 could be created, the first two data rows in the Clipboard were ignored.  Also, the date/time stamp and Operator applied to each subgroup come from the third (most recent) Clipboard row for that subgroup.

Example with three Data columns

The second example has three columns of data:

 

More:

Accessing external data via the Clipboard