We have extended our Early Bird Tickets for Inspire 2023! Discounted pricing goes until February 24th. Save your spot!

Location Data Knowledge Base

Data methodologies, and Release schedules.

Error: DUNS Number does not return any results

StephenR
Alteryx
Alteryx
Created

Environment Details


  • Alteryx Designer and Server
    • Version 2020.2
  • US Business Insights
    • All Versions

There are no error messages but querying the DUNS number will begin to return fewer results than expected.

Cause


The cause of this issue is that the DUNS number is always 9 digits long. There is the possibility that a change in how an upstream tool handles the number will drop the leading 0 in the numbers that are being matched.



Resolution


The resolution is to check to see if the DUNS numbers are 9 digits long, and prepend a 0 if they are not.