Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Community v19.6

Looks aren't everything... But the latest Community refresh looks darn good!

Learn More

UAE emirates IDs verification


Hello Community,


We have created a Customised Tool (Macro) which validates whether an emiratesID field follows the correct format as defined by the Federal Authority for Identity and Citizenship. 


The correct format to be checked is 784-YYYY-NNNNNNN-C, where 784 is the ISO 3166-1 numeric code for the UAE, YYYY is the year of birth, NNNNNNN is a random 7-digit number, and C is a check digit.




To add the tool to your tools palette :

  1. Download the attached macro to a local directory
  2. Open Alteryx Designer
  3. Click Options > User Settings > Edit User Settings
  4. Click the Macros tab within the User Settings window
  5. Click the + icon and select the directory used to save the macro(s)
  6. Enter a Category Name for the directory to appear as in the Designer
  7. Click OK
  8. Macro(s) will now show up in the category specified



To use it :

  1. Drag and drop the tool from the tool palette into the canvas. 
  2. Choose the column that contains emiratesID.
  3. After running the workflow, a new column is added at the end of your dataset showing True for correct format and False for the wrong format.  



Best to all,



Alteryx Certified Partner

@mtouiti this is neat! You might want to publish it to the Alteryx Public Gallery as that's generally the easiest way for other users to find and download it.