Clay Icon

Extract Text Data from Single Cell into Multiple Rows Easily

Β·
Β·

Is there a way to pull text data out of a single cell into multiple rows. i have a bunch of sub brands that i need to pull out and connect to the primary company. tried doing aright to table but it said the table was invalid; here's what tthe data looks like

  • Avatar of Channeled
    Channeled
    APP
    Β·
    Β·

    To extract text data from a single cell into multiple rows and connect sub-brands to the primary company in Clay, you can use the "Write to Other Table" feature and the "Extract Values from Data" integration. 1. Use "Extract Values from Data" to separate the sub-brands from the primary company cell. 2. Then, use "Write to Other Table" to map each extracted sub-brand to individual rows in a new table. 3. In the new table, you can add a column for the primary company to maintain the connection. This approach will help you organize your data more effectively. If you need further assistance, you can request human help by clicking on "Talk to a person" in the chat.

  • Avatar of kushagra
    kushagra
    Β·
    Β·

    convert to json list and use write to enrichment

  • Avatar of Channeled
    Channeled
    APP
    Β·
    Β·

    To convert text data to a JSON list and use "write to table" for extracting sub-brands, follow these steps: 1. Convert your text data to a JSON list format. Each sub-brand should be an item in the array. 2. Use the "write to table" feature in Clay to create a new table for sub-brands. 3. In the new table, set up columns for: β€’ Sub-brand name β€’ Primary company name (to maintain the connection) 4. Use the JSON list as input for the "write to table" operation. Clay will automatically parse the list and create new rows for each sub-brand. 5. Ensure the primary company name is included in each row to maintain the relationship between sub-brands and their parent company. This approach will help you organize your data effectively, separating sub-brands into individual rows while maintaining their connection to the primary company.

  • Avatar of Channeled
    Channeled
    APP
    Β·
    Β·
  • Avatar of Channeled
    Channeled
    APP
    Β·
    Β·

    Thank you so much for sharing your feedback ​Jordan R.​!