csv Input tool error

[kchiranj]

I have CSV file which consist of 19 Lakhs records how can i use this as input.

while  iam using this im able to take only 6Lakhs records by using record limit(6 Lakhs) in input configuration window.

How can i use 19 Lakhs as my input 

[messi007]

@kchiranj,

Could you share sample data of the CSV? It will help us to give you the solution.

Regards,

[kchiranj]

It's a private data @messi007, so i can't share.

is their any another way to take input?

[danilang]

hi @kchiranj 

If you remove the limit from your input tool configuration, it should load the entire file.  Can you post an image of the configuration of your input tool?  Also, can you post an image of the evidence that only 600,000 rows have loaded?  Do you see this in a results window?

Dan

[kchiranj · Accepted solution]

Hi @danilang,

Yes we should remove the limit in the configuration window and check "Treat Read errors as warnings", so we can load all the 19 Lakhs records with out any error