Combining Two or more Datasets

Ask the community
,
1

Is it at all possible to combine datasets? I cant seem to be able to copy and paste more than one cell at a time and this seems like a major time waster if I indeed have to re input every single entry over again.

Any suggestions?

2

Hi Dan,
Do you mean database collection ?
It might be faster with code.

import wixData from 'wix-data';

$w.onReady(async () => {
wixData.query('databaseCollection1')
.find()
.then(async (results) => {
  for (let i =0; i < results.items.length; i++) {
    const toInsert = results.items[i];
    await wixData.insert('databaseCollection2', toInsert)
  }
})
});

Good luck!
Roi.

3

Hi thanks for the response, I misssed it as we have been incredibly busy witha move into a new place. Now that I can return my attention to this project I will explain in more detail.

If I have a testing site that has 2 exercises on two different topics that use two different databases (exercise1 and exercise2 respectively) I want to have a periodic review test along the way. To create this test and have it select say 5 exercises from both to have ten questions covering all the material, what would my options be?

Would i have to create a new database and painstakingly enter all entries from both exercise 1 and 2?

Is there a way to connect both datasets to a new dynamic page and code a test to select from those?

Or is there a way to copy and paste rows and columns from one database to another that I havent found yet?

If any of these are possible answers or if the code that was provided above is still the answer, the clairity on the subject would be very greatly appreciated

Many thanks

4

did you ever figure this out?

5

@whitneyas Hey so there IS a workaround and it was somehow really simple but not easy to find.

So short answer to my question, no you cant copy and past in the datasets with ttthe site .

HOWEVER

When the site goes live and you hit Publish, you can EXPORT CSV files of the datasets, put it into Excel, and manipulate your data that way, then import in into a new data set.

Hope this helps, it should save you a hundred hours of work hahaha

6

Yes, for this you can use some dedicated tool like Synkronizer Excel Add-in. using this Add-in you can combine and merge multiple datasets. check it out: Merge Two Excel Files/Spreadsheets, Merge Multiple Excel Files into One Sheet - Synkronizer Excel Compare Tool