Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

How to complete missing zipcode

aozocak
6 - Meteoroid

We are using Spatial CASS function to verify addresses, but it requires address, city, state, zip as default inputs. Is there a way to run the same without a zipcode. We know that other CASS software outside supports this and actually completes the zip5 if it is missing only using address, city and state.

Thanks

2 REPLIES 2
MarqueeCrew
20 - Arcturus
20 - Arcturus

@aozocak,

 

Are  you sure that it requires ZIP to run?  I don't think that it does.  If it does, you can create a field via a FORMULA tool with a formula of Null() as a data type of string (5).

 

Cheers,

Mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
aozocak
6 - Meteoroid

I thought it requires a field with information, assuming that it will not accept a null field. But it does!

Thanks a lot :)

Labels