ALTERYX INSPIRE | Join us this May for for a multi-day virtual analytics + data science experience like no other! Register Now
2 Day Countdown - The Alteryx Community will be temporarily unavailable for a few hours due to scheduled maintenance starting on Thursday, April 22nd at 5pm MDT. Please plan accordingly.

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.