community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
#SANTALYTICS

The highly anticipated Alteryx Community tradition is back! We hope you'll join us!

Learn More
We will be upgrading the Gallery to our 2019.4 release this Saturday, December 7th beginning at 9:00am MT. We expect the outage to take last approx. 2.5 hours.
SOLVED

Convert Canadian Postal Code Ranges to Individual Values

Meteoroid

I am working with a freight carrier who can only provide the Canadian postal codes where a surcharges is applicable in ranges. I need to break them out into individual codes to compare them to another carrier.  The Canadian postal code is a six-character string that forms part of a postal address in Canada. The postal codes are alphanumeric. They are in the format A1A1A1, where A is a letter and 1 is a digit. Any help on this would be appreciated. 

Quasar

I'm not sure I understand. Could you take the first two rows and create the output you would like?

Alteryx
Alteryx

@merickson

 

I have attached workflow which uses regex to split the alphanumeric parts. Similar to @Philip not quite sure what the outcome you want is but this should give you a a start. 

 

Best,

 

Jordan Barker

Solutions Consultant 

Highlighted
Meteoroid

I have attached a complete list of Canadian postal codes. The overall objective is to identify which codes fall into the range on each record. I have highlighted the postal codes that would fall into the first range (record#1).  E6A1A0-E6A1Z9. Thanks for your help. 

Quasar

I have a solution, but can't seem to post the Alteryx Zipped solution (getting "The contents of the attachment doesn't match its file type.") I'll try sending by PM.

Alteryx
Alteryx

Hi @merickson

 

Heres my workflow suggestion. I just took a unique code from each (first four alphanumeric values) to join back up and get your ranges next to the zipcode values. 

 

Best,

 

Jordan Barker

Solutions Consultant 

 

Alteryx
Alteryx

@Philip unfortunately you cannot post yxzp files to the community. 

Quasar

That's strange. I thought I had before. Here's my solution.

Quasar

@JordanB I did upload a yxzp file here:

http://community.alteryx.com/t5/Advanced-Analytics/Is-it-possible-to-make-alteryx-workflow-same-as-A...

 

Is there different posting rules for the Advanced Analytics area?

Alteryx
Alteryx

@Philip

 

Each knowledgebase has its own rules regarding publishing file types. 

 

Best,

 

Jordan Barker

Solutions Consultant 

Labels