How to compare postal code lengths

Question

I have 2 tables:

Table1:

Record_IDCountry_KeyPostal_Code1USA100232USA20072943AR80014IN110017025BR90096

Table2:

Country_KeyPostal_lengthUSA5AR4IN7BR5

What I want to do here is to compare the lengths of the postal codes in Table1 - Postal_Code to the Postal_length in Table 2. The Postal_Code should match the number of characters that the Postal_length needs to be. I'm a beginner so not sure how or which tool i should use for this? Thank you again for the help!

DavidP · Accepted Answer

Hi @Jairacha

Welcome to the Alteryx Community.

Here is an example of how you could do this.

I start by changing the postal code from a number to a text value, which makes it easy to determine its length. Now you can match the lengths for each country from Table 2 to Table 1 and see which ones are different.

echuong1 · Accepted Answer

There are always multiple ways to achieve something in Alteryx! I personally look to streamline things and be as efficient as possible and combine functionalities to get to as few tools as possible.

Another method is to join on the country key to get the proper lengths and postal codes on the same line. From there, you can use a filter tool to check to see if they are the same length. If so, it will be returned out of the T output. If not, it will be returned out of the F output.

The same concept and formula applies if you want to create flags in a Formula.