Union of two datasets

Question

Hi,

is there a way to create a new dataset out of two present ones so that all rows of the first and all rows of the second are present in the new one?

Concrete Example: There are two databases, connected as jdbc datasources. In the first database, there is a table cat, in the second database there is a table dog. Now I can create one dataset for the cats and one for the dogs. In addition, I would like to create a dataset pets that contains all cats and all dogs with their common attributes like name, owner and dateOfBirth.

Is that possible in knowage? I looked at metamodels and federations but I didn't find a way to do it.

Thank you in advance!

Kristina

Answer 1

At the moment, this is not possible. You canuse the federator to JOIN dataset of common fieds, but UNION of dataset is not supported yet.

I agree with you that it will be a nice feature to have, and we are considering to implement it in future releases.