Alert: There is a planned Community maintenance outage October 16th from approximately 10 - 11 PM PST. During this time the Alteryx Community will be inaccessible. Thank you for your understanding!
community Alteryx IO Mission Control
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

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

dizy_11
7 - Meteor
‎05-16-2021 11:35 PM

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! 

Labels:
Reply

Accepted SolutionSolved! Go to Solution.

4 REPLIES 4
atcodedog05
22 - Nova
22 - Nova
‎05-17-2021 12:06 AM

_

Reply
0 Likes
atcodedog05
22 - Nova
22 - Nova
‎05-17-2021 12:09 AM

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

 

Reply
0 Likes
atcodedog05
22 - Nova
22 - Nova
‎05-17-2021 12:53 AM

Hi @dizy_11 

 

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

 

workflow:

atcodedog05_0-1621237327114.png

 

Can you provide more info on your usecase.

csv file.yxmd
Reply
dougperez
12 - Quasar
‎05-17-2021 03:12 AM

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

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

 

Reply
0 Likes
Labels