Clay Icon
Join the Community
01 Community General

Best Practices for Storing Large Conversion Tables in AI Prompts

Avatar of Maximilian J.Maximilian J.
·
·

Can any Clay Expert here tell me how to solve this:

  1. 1.

    Problem: Where do I store large "conversion tables" for AI prompts or formulas to access them?

  2. 2.

    Case: I want to categorize 4 digit SIC Codes into their 2 and 3 digit titles

  3. 3.

    Current approach: I have a json file that returns the correct values for each 4-digit code as an input

  4. 4.

    Current issue: When i paste the json content into a text cell it exceeds the cells file size

I want AI to access these json data in order to correctly categorize it

3 comments

  • Avatar of Joe R.
    Joe R.
    ·
    ·

    If the 4-digt SIC code to 2- and 3-digit title conversion process is deterministic, then don’t waste $ or credits on using AI. Instead:

    1. 1.

      Get AI to convert your JSON object into CSV

    2. 2.

      Import that CSV into Clay

    3. 3.

      Create a separate Clay table for your 4-digit codes

    4. 4.

      In the 4-digt code table, use Lookup Single Row (or Multiple Rows) enrichment to look up the CSV table that has your 2- and 3-digit titles to match and convert

    🙏1
  • Avatar of Maximilian J.
    Maximilian J.
    ·
    ·

    Thank you!!! This is exactly what I have been looking for!

  • Avatar of Joe R.
    Joe R.
    ·
    ·

    Nice, happy to hear it