Issue with URL Conversion in Merged Column Data Type

·May 22, 2025 11:26 AM·

why doesn't the url at 10th row show in the "merged" column saying "this value couldn't be converted to this colulmns data type (url)" despite the "company domain" column being a url

1 comment

· Sorted by Oldest

Channeled
APP
·
·
This error occurs because of a data type mismatch in your merge column. When merging columns, you need to ensure the data type of your merged column matches the data type of the source columns. The error "this value couldn't be converted to this column's data type (url)" suggests that while your "company domain" column is set as URL type, your merged column might be configured with a different data type, or there could be formatting issues with the data being merged. To fix this: 1. Click on the merged column header 2. Select "Edit column" 3. Check that the data type is set to "URL" 4. Review your merge formula to ensure it's correctly formatted If the issue persists, you might need to normalize the URL format before merging.
Sources: Table columns | Documentation | Clay University Table columns | Documentation | Clay University

Channeled
APP
·
·
This error occurs because of a data type mismatch in your merge column. When merging columns, you need to ensure the data type of your merged column matches the data type of the source columns. The error "this value couldn't be converted to this column's data type (url)" suggests that while your "company domain" column is set as URL type, your merged column might be configured with a different data type, or there could be formatting issues with the data being merged. To fix this: 1. Click on the merged column header 2. Select "Edit column" 3. Check that the data type is set to "URL" 4. Review your merge formula to ensure it's correctly formatted If the issue persists, you might need to normalize the URL format before merging.
Sources: Table columns | Documentation | Clay University Table columns | Documentation | Clay University