We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Importing text file

virginia_smith
5 - Atom

I have a text file I'm trying to import and one of the columns is a mix of text and numbers. Some numbers are formatted as 123- with the negative at the end of the number. When I import the file some numbers are missing the "-" all together. I'm importing as a flat file with fixed width. Any suggestions on importing the file so that I'm not missing any data?

2 REPLIES 2
apathetichell
20 - Arcturus

Is this file a delimited file? a fixed width file has fields at fixed spaces. that means if you say the number column is say 1-4

and the numbers look like:

1234

-123

3480

1234-

44898

 

the last characters of the last two terms will be omitted - they are not in the specific field length you set. Maybe it's tab delimited (\t) or , delimited?

OTrieger
13 - Pulsar

How is your Input Date tool set up?

Labels
Top Solution Authors