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