Best Practices for Linking Select Columns in Database Queries

When looking up a row in another table, what's the best way to "link" a select column? For example, in the pic below, "waterfall status" is a select column, but it's only showing the "option id" instead of the actual option https://app.clay.com/workspaces/423342/workbooks/wb_2yzrNp8cphiU/tables/t_zdUwNnxHERyz/views/gv_W3Vgwqq9DCKn

12 comments

Channeled
APP
·
·
To display the actual option value instead of the option ID when linking a select column from another table in Clay, you'll need to adjust the column settings. Here's how you can do it:1. Right-click on the column that's displaying the option ID. 2. Click on "Edit Column" and then "Select Data Type". 3. Choose the appropriate data type for the column, which in this case would likely be "Select" or a similar option that allows for dropdown values. 4. Save the settings for the column.This should update the column to display the actual option values instead of just the IDs.To ensure you're viewing the correct data, you may also want to check your table view:1. Click on "Default View" at the top of your table. 2. Select the view that shows the columns you need, or create a new view if necessary.Can you tell me which specific tables you're working with and what kind of data you're trying to link? This would help me provide more tailored advice for your situation. Sources: Select Column Data Type Views
Mathew I.
·
·
Person
Channeled
APP
·
·
In Clay, companies and people data tables are automatically linked when using the Find People process. The second column in your Find People Table will display the corresponding company name for each prospect, using the "Lookup Single Row in Other Table" feature.To ensure the correct data type is displayed:1. Right-click the column you want to edit 2. Click "Edit Column" > "Select Data Type" 3. Choose the appropriate data type for the column 4. Click "Save Settings"This should help display the actual select column values instead of option IDs in your Person table.Can you provide more details about which specific column in your Person table is currently showing option IDs instead of the desired values? Sources: Find People [Clay 101] - Clay University Select Column Data Type
Mathew I.
·
·
that didn't work
Channeled
APP
·
·
To display or manage column values in your table, here are the steps you can take:1. To show hidden columns: • Click "columns" above the table • Toggle the columns on individually • Or click "Show All" to display all columns 2. To adjust column settings: • Right-click the column you want to edit • Click "Edit Column" > "Select Data Type" • Choose the appropriate data type • Click "Save Settings"If you're still experiencing issues, you can request human assistance by clicking on "Talk to a person" for additional support. Sources: Select Column Data Type Hide, Re-order, Sort, Filter, Merge Columns
Mathew I.
·
·
That does not answer the question
Mathew I.
·
·
Please pass this to a person
Channeled
APP
·
·
Looks like you're still looking for help. We're escalating this over to our support team and someone should be in touch soon. In the meantime, feel free to include any other information that may be helpful in solving your issue!
Arturo O.
·
·
Hey Mathew, thanks for the inquiry! Jumping into the convo for the bot. It looks like we've got a bug on our hands. I've escalated this to our engineering team to help look into it. We'll follow up here as soon as we know more! The best workaround for now would be to instead of using a Select type of column to use standard text (with conditional formulas if needed). The Lookup has been running into issues where it can't pickup the values from Select fields which is what I reported.
Mathew I.
·
·
Cool -- thanks. yeah, i had to make a duplicate text field in the original table and just displayed that instead
Arturo O.
·
·
Nice! Glad that works then. I've attached the link to the bug to this conversation so we can confirm once it's fixed. Let me know if you run into any other issues, of course!
Mathew I.
·
·
Cool thanks