Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Register for the upcoming Live Community Q&A Session - and don't forget to submit your questions for @DeanS regarding the future role of analytics here.
SOLVED

How to complete missing zipcode

Highlighted
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

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

@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 reboot. Order shall return.
Highlighted
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