Last Updated: Feb 14, 2022
In automation scenarios, when you need to combine two or more datasets, you can use the Join option.
In the Product Inventory Management HyperApp, the two datasets must be combined, modified, and the net Product Inventory updated based on the sales.
You can combine the data from two or more Datasets into a single Dataset based on common criteria or field.
For advanced Join criteria, you can write the the desired query using the SQL Query Editor.
You can preview the table data using this option.
Click the icon against the Dataset and click the Preview button. Multiple datasets are displayed at the same time.