Configuring LinkedIn Company ID Field as Text in Database Setup

Laurent H. · 2025-11-24T15:39:39.492Z

Hi When creating a company table, I noticed that the LinkedIn company ID field is treated as a number (some of them are negative), which means I have to create a column to convert this field to text. Would it be possible to configure this field as Text from the outset?

Configuring LinkedIn Company ID Field as Text in Database Setup | Clay

7 comments

· Sorted by Oldest

Clay Support
APP
·
·
Yes, you can set the Company ID field as text when creating or editing your table. When adding a new column, just choose the "Text" data type instead of "Number." If the column already exists, click the column header, select "Edit column," then change the data type to "Text" and save your changes. This will prevent issues with negative values and formatting in your Company ID field [1] [2] [3].
Clay Support
APP
·
·
Was that helpful?
Clay Support
APP
·
·
If you still need help with configuring the Company ID field or have any other questions, I’m here to assist. Would you like to provide more details about what you’re trying to achieve or any other issues you’re facing?
Laurent H.
·
·
This information comes from the companies' native enrichment. Even if I change the data type, I still get negative values. If I add a formula, it adds a new column. This value is a company ID. It should be a text field, not a number field. No arithmetic operations will be performed on this value.
Clay Support
APP
·
·
Currently, when company data is enriched natively, the Company ID field is set as a number by default, which can result in negative values and formatting issues. You can manually change the column type to Text by clicking the column header, selecting "Edit column," and switching the data type to Text. However, if the enrichment process keeps overwriting this as a number, you may need to create a new Text column and use a formula to convert the ID to text. There isn’t a way to force the enrichment to treat this field as text from the outset, so a manual workaround is needed for now [1] [2].
Clay Support
APP
·
·
Was that helpful?
Clay Support
APP
·
·
I understand this situation can be frustrating, and I’m here if you need more help with the Company ID field or any other issue. Would you like to share more about what you’re trying to resolve so I can assist further?