Paste Data (e.g. From Excel)

From Q
Jump to: navigation, search

You can paste in a new variable as follows:

  1. Open Excel and copy the variable that you wish to paste.
  2. In Q, go to the Data tab.
  3. Set the Case ID using the drop-down at the top-left of the Data tab.
  4. Go to the Variables and Questions tab.
  5. Right-click on the row number where you want to paste the variable.
  6. Insert > Variable(s) > Paste Data (e.g., From Excel) and answer the question it asks

If pasting multiple variables, the first row must contain variable names (i.e., and thus they may not have punctuation or unusual characters in them, such as spaces or returns).

Contents

The "Not enough values included" error message

Sometimes when pasting an error message can appear which says something like:

Not enough values included. The number of values pasted in must match the number of values in the rest of the data (1879). The clipboard contains 2031 values.

Assuming that you have checked that the number of rows you are pasting is the same as the number of rows in Q, the explanation for this is likely to be that there are inappropriate characters in your data. Most commonly these are various types of return characters, but it is possible that there are other invisible characters in the cell.

Bugs in Excel make this a slightly painful process. In theory, the first approach below should be sufficient, but in practice it is often necessary to do the others as well.

Find and Replace 1

  • In Excel, select all the cells that you want to paste into Q.
  • Open up Find and Replace.
  • Put your cursor in the Find what box, hold down the Ctrl key on your keyboard and press the j key. It will not look like much has happened, but if you look carefully you should see a small flashing comma.
  • In the Replace with box type // (or whatever else you would like to use to indicate a new line).
  • Press Replace All.

Find and Replace 2

  • In Excel, select all the cells that you want to paste into Q.
  • Open up Find and Replace.
  • Put your cursor in the Find what box, hold down the Alt key on your keyboard and quickly type 0010. It will not look like much has happened, but if you look carefully you should see a small flashing comma.
  • In the Replace with box type // (or whatever else you would like to use to indicate a new line).
  • Press Replace All.

Refreshing Excel

  1. Close and restart Excel.
  2. Remove any auto-filtering-
  3. Check that you are not using Excel in Read Only mode.
  4. Do the Find and Replace approaches again.

Using clean

Use Excel's clean formula.

Personal tools
Namespaces

Variants
Actions
Navigation
Categories
Toolbox