Clay Icon
Join the Community
02 Support

Issue with URL Conversion in Merged Column Data Type

Avatar of Dipson S.Dipson S.
·
·

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

  • Avatar of Channeled
    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.