cartesian-product
Combine rows in multiple worksheets to get all possibilities. A step-by-step.
When applying the cartesian product directive to two worksheets A and B, this directive pairs every row in worksheet B with every row in worksheet A. The resulting row set would have as many rows as the total number of rows in worksheet A multiplied by the total number of rows in worksheet B.
Use Case Tip
Cartesian products are great for applying multiple discounts to a customer's basket of items. Whenever you have a group of percentages that you need to apply to every item using a cartesian product is a good bet.
Adding 'cartesian-product'
Step 1: Click the "Add Directive" button on your dashboard
![1.png 600](https://files.readme.io/f5df73d-1.png)
Step 2: Choose "Cartesian-product"
![2.png 600](https://files.readme.io/1327218-2.png)
Step 3: Select the worksheets you'd like to add
For 'cartesian-product', you'll be able to connect more than 2 worksheets.
![3.png 600](https://files.readme.io/f6e707a-3.png)
![4.png 600](https://files.readme.io/e8235e1-4.png)
![5.png 600](https://files.readme.io/39990db-5.png)
For 'cartesian-product', you'll be able to connect more than 2 worksheets.
![7.png 600](https://files.readme.io/17df9fc-7.png)
![9.png 600](https://files.readme.io/a3ce9a4-9.png)
Easily remove your extra selection
Step 4: Once you're happy with your selection, click 'Add'
![10.png 600](https://files.readme.io/3bdde7f-10.png)
Step 5: Name your output worksheet
This will be where your output data from connecting the worksheet by adding 'from' will be.
![11.png 600](https://files.readme.io/a7e3854-11.png)
Step 6: Once you've inputted your output worksheet name, you're ready to add the directive!
![12.png 600](https://files.readme.io/8af3884-12.png)
Voilà, success!
Your spreadsheet will automatically take you to the output worksheet. See the results of combining those worksheets you've choosen!
![14.png 600](https://files.readme.io/7f0460c-14.png)
For more technical and in-depth information on our 'cartesian-product' directive, do visit our Pebble Stream Enterprise Documentation
Updated about 2 years ago