Clay Icon

Feeding Column Data to LLMs: Does Clay Support This?

Β·
Β·

say i have a entire column (several hundred rows) of data and I want to take JUST the values in that column and feed that into an LLM as a series of data - is there a straightforward way of doing that in Clay at the moment? i can always export it as a data series, just curious if this functionality already exists

  • Avatar of Channeled
    Channeled
    APP
    Β·
    Β·

    Yes, there are a few straightforward ways to work with column data in Clay without exporting: 1. Use the "Extract Values from Data" feature to isolate specific data from a column. 2. Reference the entire list of data in a column using the "Insert all items" option. 3. Create child columns from a parent column to map out specific endpoints. 4. Use our "write to table" feature to map list items to individual rows in another table. These methods allow you to manipulate and use your column data within Clay before feeding it into an LLM or other processes.

  • Avatar of Nir B.
    Nir B.
    Β·
    Β·

    ok so let's say i want to feed an entire column (and all its associated rows from value x to value y) into a prompt inside of Claude sonnet 3.7 - how would i set that up in clay? where is this "insert all items" located?

  • Avatar of Channeled
    Channeled
    APP
    Β·
    Β·

    To feed an entire column and its associated rows into a prompt for Claude Sonnet 3.7 in Clay, you can use the "Use AI" enrichment feature. Here's how: 1. Open your table and click "Add Column" > "Add Column using AI". 2. In the Prompt Editor, you'll find options to reference data from other columns. 3. To include all items from a specific column, use the dynamic input feature. This allows you to reference the entire column's data. 4. Write your prompt for Claude, incorporating the column data where needed. Note that there isn't a specific "Insert all items" feature. Instead, you can reference the entire column using dynamic inputs in the AI prompt. If you need to map out lists to individual rows in another table, you can use our "write to table" feature. This might be helpful if you want to process the data before sending it to Claude.

  • Avatar of Nir B.
    Nir B.
    Β·
    Β·

    what do you mean dynamic inputs - dynamic inputs will only reference a particular value of a given column AT a particular row - NOT all rows in that column as a single payload of data

  • Avatar of Channeled
    Channeled
    APP
    Β·
    Β·

    Currently, there isn't a direct way in Clay to feed an entire column of data as a single payload into a prompt for Claude Sonnet 3.7. However, you can use the "Use AI" enrichment feature to work with column data. Here's how: 1. Open your table and click "Add Column" > "Add Column using AI". 2. In the Prompt Editor, you'll find options to reference data from other columns. 3. Use dynamic inputs to reference specific fields from your data columns. 4. Write your prompt for Claude, incorporating the column data where needed. Keep in mind that dynamic inputs reference values from individual rows, not the entire column at once. If you need to process all rows together, you might need to use our "write to table" feature to prepare the data first. For more complex data handling, you may need to explore custom solutions or reach out for further assistance.

  • Avatar of Nir B.
    Nir B.
    Β·
    Β·

    how would "Write to table" solve this - doesn't it just map rows and columns to other tables? how would it allow me to aggregate all the values in a column in another table?

  • Avatar of Channeled
    Channeled
    APP
    Β·
    Β·

    Our "write to table" feature doesn't directly aggregate all values from a column into another table. However, you can use it to transfer data between tables, which can be a step towards aggregation. Here's how you can approach this: 1. Use "write to table" to transfer the column data to the destination table. 2. In the destination table, you can then use Clay's data manipulation features to aggregate the transferred data. For the transfer: 1. Set up "write to table" and select your destination table. 2. Map the column you want to aggregate to a column in the destination table. After transfer, you can use Clay's column operations or AI features in the destination table to perform the aggregation you need. If you need more specific guidance, please provide details about your desired aggregation method.

  • Avatar of Nir B.
    Nir B.
    Β·
    Β·

    how would you use Clay's data manipulation features to do that

  • Avatar of Channeled
    Channeled
    APP
    Β·
    Β·

    To aggregate all values in a column using Clay's data manipulation features, you have a few options: 1. AI Formulas: Use this powerful feature to process and structure data without using credits. You can write a formula to aggregate values from your column. 2. "Extract Values from Data" feature: This can help you isolate specific data from a column. 3. Reference entire lists: When working with list data, you can use the "Insert all items" option to access the complete set of data at once. 4. Normalize and Deduplicate: This feature can help clean and organize large object lists, which might be useful depending on your aggregation needs. For more complex aggregations, you might need to combine these methods or use our "write to table" feature to prepare the data first.

  • Avatar of Channeled
    Channeled
    APP
    Β·
    Β·