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

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!

Input

Accepted answers

atcodedog05

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-do-I-change-it-to-a-a/td-p/669527

All comments

atcodedog05

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-do-I-change-it-to-a-a/td-p/669527

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.

csv file.yxmd

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-a-csv/td-p/365101

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15880

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703