Clay Icon

Extracting Data to New Table with Profile URL and Job Title Headers

Ā·
Ā·

Hi, how can i extract this data in either same table creating multiple columns or else in a new table with different multiple rows and 2 headers (Profile URL and Job title), can you help please?

  • Avatar of Channeled
    Channeled
    APP
    Ā·
    Ā·

    There are several ways to handle this:1. To extract specific values and create new columns: ā€¢ Click "Add Column" > "Add Column using AI" ā€¢ Enter a description of what you want to extract (like Profile URLs or Job Titles) ā€¢ Set up the parameters and click "Save" 2. To extract and organize data within the same table: ā€¢ Use the "Add Column" > "Merge columns" option to combine data if needed ā€¢ Use filters to organize the data by selecting specific columns and applying conditions like "contains" or "equal to" 3. For extracting specific values from complex data: You can use the Extract Values feature to identify and retrieve targeted information like URLs from your existing data. This helps streamline the process of isolating relevant information from your dataset. Sources: Hide, Re-order, Sort, Filter, Merge Columns Extract Values from Data with Clay Add Column Using AI & Add New Rows

  • Avatar of Channeled
    Channeled
    APP
    Ā·
    Ā·

    This thread was picked up by our in-app web widget and will no longer sync to Slack. If you are the original poster, you can continue this conversation by logging into https://app.clay.com and clicking "Support" in the sidebar. If you're not the original poster and require help from support, please post in 02 Support.

  • Avatar of Bharat S.
    Bharat S.
    Ā·
    Ā·

    Thank you, Bruno helped me out, still there is one issue for "profiles" message there is no result so i want simply to return in the column no result instead of this confusing message. Bruno R.