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.

Download Example

👍

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

600600

Step 2: Choose "Cartesian-product"

600600

Step 3: Select the worksheets you'd like to add

For 'cartesian-product', you'll be able to connect more than 2 worksheets.

600600 600600 600600

For 'cartesian-product', you'll be able to connect more than 2 worksheets.

600600
600600

Easily remove your extra selection

Step 4: Once you're happy with your selection, click 'Add'

600600

Step 5: Name your output worksheet

This will be where your output data from connecting the worksheet by adding 'from' will be.

600600

Step 6: Once you've inputted your output worksheet name, you're ready to add the directive!

600600

Voilà, success!

Your spreadsheet will automatically take you to the output worksheet. See the results of combining those worksheets you've choosen!

600600

For more technical and in-depth information on our 'cartesian-product' directive, do visit our Pebble Stream Enterprise Documentation


What’s Next
Did this page help you?