Hi Mimi,
OK, now I understand. I think the right answer is that you should do it in a spreadsheet by appending a column to the Laundry dataset and filling it with “Laundry.” Then, when you import this into CODAP, you can drag that column to the left to create the parent “Location” collection.
But you inspired me to see if there was any way to do it from within CODAP. There is, but it’s very clumsy, and I don’t recommend it. But here are the steps, at least approximately:
- In the “top 2” dataset make a new attribute named “Time”
- Drag the case and location attributes to the left, leaving Time on the right.
- Click in the Index column of the child collection and insert as many cases as you have in the Laundry dataset.
- Give the Time attribute a formula like the one in the screenshot below, except referring to “Time” instead of “Temperature.”
This should have transferred all the temperature values into the top 2 dataset at the child level. Add the rest of the attributes, varying the formula to refer to each additional attribute in the Laundry dataset.
What a lot of work! Much easier in a spreadsheet.
There are a lot of data manipulation capabilities we would like to add to CODAP as we go along. “Ease of join” is certainly one of them!
Bill
