Multiple Datasets

There are certain cases where the source data is composed of several data tables. It’s especially the case when getting JSON data from a Webservice or a MongoDB database.

Fuzible is packed with an in-house JSON parser : it can read any JSON data, create multiple data tables and link them with keys. This means, for exemple, that a complex JSON data schema can be fully retrieved and sent into a database as multiple linked tables !

But, if you have read the Basics, you can ask yourself how a simple “SELECT * FROM MYJSONFILE.JSON” can be magically converted as a full data schema.

That’s why I added a simple SQL keyword that allows you to choose the data tables you want to retrieve or the data tables you want to operate with.

How does it work ?

In this example, I’m querying a MongoDB collection containing 2 data tables.

The Source data is presented as follows :

Now, I want to get only the “_id” field from the first data table.

The Source data will now look like :

Now, I only want to retrieve the second data table :

The Source data will now look like :

Now, I want to retrieve both data tables, but I still want the query to be associated with the second data table :

The Source data will now look like :

… and if I want to perform a query on both data tables ?

Just write two queries !