Thank you for the suggestions.
The issue was with the length of the address column. The original csv file had a maximum length of 222 characters for the address column. but after importing it to the LASR server and working with it in a data query, I found that the length had changed to 145. I tried to change it back to 222, but when I tried to use that column in my list table, I encountered that error of 'some formats ...' and to address this I imported the csv file again using a SAS program instead of the Data Builder import interface and I added the option guessingrows=max to ensure the full length of each column was imported, which resolved the problem.
Thank you
... View more