Clay Icon

Exporting Sequence Strategies from Table to a New Row-Based Table in Clay

ยท
ยท

Here is the URL for my table where I have 2 companies that I've built an sequence strategy for: https://app.clay.com/workspaces/137689/tables/t_9dXXwpeyqllQ/views/gv_fhckbJ94bNyt In the table I've extracted a break down of the different sequences to launch as different columns (Sequence 1, Sequence 2, etc) I want to write that to a new table but now each sequence must be a new row, to this table for example: https://app.clay.com/workspaces/137689/tables/t_LceH88s42DRC/views/gv_6GHZg5vhswMd I'm struggling to get each sequence column to write to a new table as a new row

  • Avatar of Daniel G.
    Daniel G.
    ยท
    ยท

    Done

  • Avatar of Clay T.
    Clay T.
    APP
    ยท
    ยท

    Hey Daniel, So sorry for the delay! Just to confirm - Is this fully resolved? Is there any of the process that's currently blocking you? Happy to help๐Ÿ™๐Ÿฝ

  • Avatar of Daniel G.
    Daniel G.
    ยท
    ยท

    No not resolved at all - definitely need your help

  • Avatar of Stefan K.
    Stefan K.
    ยท
    ยท

    Daniel G. this is definitely a more complex workflow - but possible! You'll need the OpenAI columns to output those sequences in an array format if you want them to be sent into another table and show up as a row. For example:

    • Prompt: Please return company domains for each as a json array of domains /domain

    • openai column shown in the screnshot

    • write to table using that openai column

  • Avatar of Daniel G.
    Daniel G.
    ยท
    ยท

    Ohhhhh I likey!

  • Avatar of Daniel G.
    Daniel G.
    ยท
    ยท

    The array is still coming up as text in the reponse ๐Ÿ˜ž

  • Avatar of Daniel G.
    Daniel G.
    ยท
    ยท
  • Avatar of Daniel G.
    Daniel G.
    ยท
    ยท
  • Avatar of Daniela D.
    Daniela D.
    ยท
    ยท

    Hey Daniel, So sorry for the delay! I'm taking a look now.

  • Avatar of Daniel G.
    Daniel G.
    ยท
    ยท

    Really struggling now, seems like the array is correct in terms of it's structure

  • Avatar of Daniel G.
    Daniel G.
    ยท
    ยท

    Bumping this

  • Avatar of Daniela D.
    Daniela D.
    ยท
    ยท

    Hey Daniel, Currently testing this. We're testing to see if it's an issue with the format. Really sorry for the delay๐Ÿ™๐Ÿฝ

  • Avatar of Daniel G.
    Daniel G.
    ยท
    ยท

    No worries, I've been fiddling too, this is my latest:

  • Avatar of Daniel G.
    Daniel G.
    ยท
    ยท