In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

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

Limited Field Length - CSV document

AlbertoALRM
5 - Atom

Hello everyone, 

 

I am parsing a CSV document, which has a 254 field length. The document has no delimiters, all characters are all together without spaces.

 

AlbertoALRM_0-1635935598774.png

 

I am using the formula tool to parse the data, using the Substring function. After reaching the 254 field length in the formula, Alteryx does not show any more values/characters. 

 

AlbertoALRM_1-1635935648678.png

 

To solve this problem I have tried the following:

 

1) In the input tool I have set the field length to a very high number (let´s say 1.000.000), it hasn´t work the result remains the same. 

2) I have inserted a select tool after the input tool and change the size to a very high number (let´s say 1.000.000), it hasn´t work the result remains the same. 

3) I have inserted a formula tool and use the Length formula and the result has been 254. 

 

Let me know if there are any ways to solve this problem. 

 

Thank you in advance.

 

8 REPLIES 8
PangHC
12 - Quasar

if 1,000,000 not enough, just extend it to 1,073,741,823.  (Max size the alteryx have.)

 

Pang_Hee_Choy_1-1635936856913.png

 

if still not enough, you may need to try to either change your data source or change tool to use.

 

beside, i saw you manual split the data, you can try this way. (if the data is split by fixed length)

Pang_Hee_Choy_0-1635936811014.png

regex formula : (.{10}|.{0,10}$)

Pang_Hee_Choy_2-1635936987042.png

 

mceleavey
17 - Castor
17 - Castor

Hi @AlbertoALRM ,

 

can you post a sample of the data so we can help?

 

M.



Bulien

Tony_Castillo
9 - Comet

In your Input tool, trying changing the Delimiters to \n

 

Also, update the Field Length in the Input Tool to 254000000

 

Tony_Castillo_0-1635942156418.png

 

AlbertoALRM
5 - Atom

Hello, 

 

I have tried to extend it to 1,073,741,823.  (Max size the alteryx have.), but is still not working. 

 

The data is not split by fixed length unfortunately. 

 

 

AlbertoALRM
5 - Atom

Hello Tony, 

 

I used your suggestion and although I do not see all the fields in the formula tool I can see there are all fields in formula output. 

 

AlbertoALRM_0-1636010917619.png

 

Your solution may have partially solved the problem. 

 

Thank you. 

Tony_Castillo
9 - Comet

@AlbertoALRM If you could share a sample of what the file has (# of columns, record values, etc), then we can help unwind further. 

PangHC
12 - Quasar

just realise if it pure number, the text length is double up to 2147483647 (2,147,483,647)

Pang_Hee_Choy_0-1636365213270.png

 

Tgigs
8 - Asteroid

I have a text file that contains 1000 lines with long strings. I read in with no delimiter and field length 16777216. Setting this field length is max you can read from CSV.

 

Capture.PNG

Labels
Top Solution Authors