Import all records of csv excel file which has more than 1048575 rows

[dizy_11]

Hi all,

I am working with a CSV excel file which has 37 lakh rows. When importing in alteryx it's importing only 10 lakh rows. Can anyone please provide solution on how can i import whole records without truncating any.

[atcodedog05 · Accepted solution]

Hi @dizy_11 

Hope this post helps you https://community.alteryx.com/t5/Alteryx-Designer-Discussions/I-have-an-extremely-large-csv-file-how... 

[Qiu · Accepted solution]

@dizy_11 

maybe try these two.

1. Restart your PC 

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Input-Tool-CSV-limits-only-loading-100...

2. Import the data by batch, say batch A for Row 1 - 1000000 and batch B for 1000001 to last

[danilang]

Hi @dizy_11 

You say "When importing in alteryx it's importing only 10 lakh rows".  Why do you think that some of the rows are missing?  Post a screen shot of where you see that some rows are missing?

Dan