The Model feature allows you to easily perform data wrangling on messy data and connect multiple data tables into one. If you have complex and big data coming from different sources (i.e. Excel, Google Sheets, Facebook Ads, Shopify, HubSpot, etc.), Y42 allows you to combine and transform these data sources. There is no need for coding and the entire model is very easy to use and visual.
Watch the following video for a more comprehensive overview on Model:
Note: In order to use the Model feature you should have already imported data sources into Y42.
Adding a Data Model to your Y42 Platform
Click on Model in the left navigation bar.
Click Add... in the top right-hand corner of your screen and choose the Y42 Model data source. Type a name for your model, and choose whether it should be public or private.
Click on Create.
A new data model is being created. You will be automatically redirected to the data Model application.
Inputting data tables
Data models are comprised of inputs, transformations, and outputs. In this article, we will go over the basic structure without going into detail about the specific transformations.
Import a table by dragging and dropping the Input node into the middle. You can add as many input tables as you want.
Click on each input added and assign them a data source table you have already added (you can always change the data source assigned to an input), then click Apply.
Now that you have the raw data imported into your model, you can drag and drop the transformations node close to the inputs. The nodes will automatically connect. Alternatively, you can connect them by manually creating a link between the nodes:
Tip: Manually connecting the nodes like this is a good practice especially when your data blend becomes more complex.
Click on the node to input the necessary information and settings.
After you're done transforming your raw data, drag and drop the Output node to the transformation path and click Commit Model to create your new output. You can create as many outputs as you would like for each transformation path.
Deleting Connections Between Nodes
You may want to change and re-adjust the connections between nodes.
Click on the connecting link to select it.
Press your backspace key (for Mac users) or your delete key (for Windows users).
To delete a note from your structure, simply right click the node. Select Delete in the menu.
What transformations can I perform?
Click here to find out more about the different transformations the Model feature allows you to make to get your data perfect for analysis.