community
cancel
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

Highlighted
Alteryx
Alteryx

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.

 

ID.jpg

 

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

ID4.PNG

 

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.  

ID3.PNG

 

Best to all,

 Mohamed

 

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.

Labels