Forum Discussion
Solved
Zip Code Columns and 9 Digits
I have Text Columns for all my Address columns. It works great for 5 digit zip codes but I get error whenever it sees a 9 digit zip code 95076-1023 for example. How do I resolve this?
I had some unexpected Applied Steps that were created when I changed source file. I deleted those out and all was good again.
The code you posted is from the 'Show errors' - it doesn't tell me much but it does tell me that you have a lot of fields in your original query and, like I said before, the zip code column looks like it has a number type.
So please amend the original query and change the column to text type