limitations on txt inputs

[binnursev]

Hi community, 

I am having an issue with my input file. I have an input that is separated with a unit separator, I finally able to bring it to workflow and use text to columns tool to separate my values. However, I noticed the txt file with 800000 rows are coming out as 100000 values. Is there a limit of Alteryx on txt inputs? Is there a way to increase it?

Thanks a lot! 

[mceleavey]

Hi @binnursev ,

it would depend on your data format and how you are splitting it.

If you can share the data we can have a look.

M.

[mceleavey]

Also, check with a browse tool to ensure it's not just the limit of the tool node, rather than the full dataset.

M.

[binnursev]

Thank you for your reply. I checked with the browse tool but it still takes 1/8 of the input values. I have two other files with the exact same structure and I used the same tools and it works out perfectly. Only the file with 800000 values has this issue so I think it is not related to the text to columns tool. 

[danilang]

Hi @binnursev 

Assuming you don't have a Record Limit in the config of your Input tool, add a Count tool after your Input.  This will tell you how many records are being read by the Input tool.   If the the Count is 800K then the issue is further in the workflow.  If it's only 100K then the issue is in the Input tool.  

Dan

[binnursev]

Hi @danilang, 

Thanks a lot for the answer. I tried Count records and it was showing100K records and there is no Record Limit in my input tool. Do you know if there is anything else I could check or configure? 

Best regards

Binnur 

[HomesickSurfer · Accepted solution]

Hi @binnursev 

I wouldn't use the text-to-column tool.  Import your file as Flat ASCII, allow long and short lines, trim in required, separate your fields, name them, assigned type, etc..and increase the record lenghts..

[binnursev]

Hi @HomesickSurfer 

This is an amazing solution and I will surely use it in my next workflow. I found out that the problem was not related to Alteryx and more about the data file being modified somewhere before. Thanks a lot for your help.

Best