Unstack Data Rows on Import

Some files contain data for multiple assessments in a single file (i.e.  Math and ELA). Previously, since a single student is listed multiple times, users were unable to upload the file without altering the file first. This new feature makes it easy for users to break apart a file and upload one assessment at a time.

In the following example, the file has both Math and ELA test date. We will upload ONLY the Math scores without altering the original file. 

To do this, follow these steps:

1. Select Data Manager
2. Choose the NJSLA Math template
3. Create or select an existing snapshot
4. Choose Actions
5. Select Import
6. The Data Import Wizard opens
7. Step 1: Table Info
   • Select a snapshot
   • Click the Choose File button
   • Select a file
   • Click the Next button (and the file will upload)
8. Step 2: Import Rules
   • Choose the Local ID Column (and/or State ID Column)
   • In the Row Filtering section choose which "rows to include or exclude"
   • Select Subject in for "the row that will be included or excluded"
   • Choose Mathematics in the "contains any of the following values" field
   • Click the Next button
9. Step 3: Validation Results
   • A summary of valid and invalid rows is visible here
   • When you're finished, click Finish
10. The uploaded files are visible in the Snapshots tab