limitations on txt inputs

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!

Workflow

Input

Accepted answers

HomesickSurfer

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..

All comments

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.

mceleavey

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

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.

HomesickSurfer

Hi @binnursev

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

Quick Links

This months top contributors

AkimasaKajitani 387

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335