Explains what the feature is or what its benefits are to the user or customer.
After creating an answer from a worksheet (also called an aggregated worksheet) and linking it to related data, you're ready to create your search. You can save the new search as a worksheet too, so that you can search it directly and share it with other people.
- Click the search icon, and select Data Source. Choose your linked sources.
- Do a search using columns from the linked sources, including any aggregations you created.
- Test the result, to make sure it’s what you expect. If your search shows no data found or doesn't look right to you, it is possible that one of the links between your sources was made on the incorrect column. Check the relationships you created and try linking using a different column, to see if that gives the expected search results.
- Once you have the expected answer, you can create a worksheet to make it easier for you and other people to use. To do this, click the Data icon.
- Click the Actions icon from the upper right side of the screen, and select Create Worksheet.
- Choose both views using Choose Sources.
- You may need to rename some columns appropriately for searching.
- Share the worksheet with the appropriate users and groups.