how can i put the output of a search result into multiple columns? For instance i want to run a search to find out whether a company deals in specific furniture products and if it does i want the result to be reflected in different columns
You can use the "Format Categories Based on Keywords" feature to organize your search results into different furniture product categories. Here's how:1. Set up your items to categorize as an array of your search results 2. Create categories and define keywords for each furniture type (e.g., "Chairs": "chair, stool, seating", "Tables": "table, desk, dining") 3. Specify your output schema to map the fields you want to see in your resultsThe system will automatically categorize each item based on your defined keywords, and the results will include a "clay_category" field by default to show which furniture category each item belongs to. Source: Format Categories Based on Keywords with Clay