How to import all the rows of a large CSV file without truncating any

[dizy_11]

Hi,

I am working with 3 CSV files. Each has 3 Lakhs of rows. When I am importing those it's getting truncated. Can anyone please provide me a solution so that every rows can get imported  for all files.

Thanks! 

[atcodedog05]

_

[atcodedog05 · Accepted solution]

Hi @dizy_11 

I was able to find this post with similar this might be helpful https://community.alteryx.com/t5/Alteryx-Designer-Discussions/I-have-an-extremely-large-csv-file-how...

[atcodedog05]

Hi @dizy_11 

I tried to replicate the use case by creating a .csv file with 500000 records and read it.

workflow:

Can you provide more info on your usecase.

[dougperez]

I found this link, i think this will help you:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Cell-text-is-truncated-when-importing-...