match-rows
Drag down your formula by combining two worksheets. A step-by-step.
This directive will generate as many rows in the current worksheet as there are in the target worksheet.
Important Note
The target worksheet should contain a formula and reference another worksheet
Adding 'match-rows'
Step 1: Click the "Add Directive" button on your dashboard
![1.png 600](https://files.readme.io/addd1eb-1.png)
Step 2: Choose "match-rows"
![2.png 600](https://files.readme.io/bae7150-2.png)
Step 3: Select the worksheets you'd like to add
- The target worksheet is the worksheet to which you'd like to add match-row to and should be the worksheet that contains formula.
- Source worksheet is the worksheet you're pulling data from to connect to your target worksheet.
![3.png 600](https://files.readme.io/46a4a68-3.png)
![4.png 600](https://files.readme.io/add9e54-4.png)
![5.png 600](https://files.readme.io/63cb907-5.png)
Step 4: Once you're happy with your selection, click 'Add'
![7.png 600](https://files.readme.io/b9085b8-7.png)
Voilà, success!
Your spreadsheet will automatically take you to the target worksheet. See the results of combining those worksheets you've choosen!
![9.png 600](https://files.readme.io/2807254-9.png)
For more technical and in-depth information on our 'match-rows' directive, do visit our Pebble Stream Enterprise Documentation
Updated about 2 years ago