Import all records of csv excel file which has more than 1048575 rows
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
Solved! Go to Solution.
- Labels:
- Input
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @dizy_11
Hope this post helps you https://community.alteryx.com/t5/Alteryx-Designer-Discussions/I-have-an-extremely-large-csv-file-how...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
maybe try these two.
1. Restart your PC
2. Import the data by batch, say batch A for Row 1 - 1000000 and batch B for 1000001 to last
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
