Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I'm loading some fairly sizable data from pipe-dlimited txt files.
The largest file has 3mill rows and loads just fine.
But one of the files with 690k rows ony loads a selection of 317k rows. I cannot figure out what the issue is - it's not simply stopping at a certain point, but actually dropping . ignoring certain rows. If I open the file in excel and save it as .csv then I can load all the rows. So it looks like a potential issue with hidden characters or file format.
Any advice on how to isolate this problem?
change the quoting.
Try standard instead of MSQ
change the quoting.
Try standard instead of MSQ
Does it stop at the same row each time? If that is the case, try importing a few lines before and after your problem area to see if the problem is still there. If that's the case the problem is in your input txt-file.
That did the trick!
Thanks!