I use the CSV provider to load a folder with multiple CSV files. I know one of the files has 17471 rows. Only the ingest task only loads the first 14521 rows. I don't have any filtering in the ingest task.
Does anyone know how I can load the full file?
Best answer by rory.smith
Hi,
nice mug :-)
there are quite a few possiblities in CSV depending on the contents of the file:
In the worst case you can cut your CSV in half and try loading it, if you keep doing that you should find the records leading to issues.
Your first statement would seem to indicate there is some kind of key clash going on, your second statement seems to indicate there is some kind duplicate item (source name, table name, field name) that is not expected.
+5
+7Hi
Perhaps all the rows did load, but due to a filter or a Primary Key setting some records are not visible?
+5
Can you send a file with all records? if the file contains sensitive data that you are willing to share with our support team but not here in the community, then please send to support@timextender.com
+7Can you figuer out which records have not been loaded? Do they have the same attributes? The same data perhaps?
I think the answer lies in the data.
I think the answer lies in the data.
This is deep. Very deep. I need a coffee mug with that text.
+7Happy to help. You digital mug is on it way
Hope this helps
= Daniel
+7Hi,
nice mug :-)
there are quite a few possiblities in CSV depending on the contents of the file:
In the worst case you can cut your CSV in half and try loading it, if you keep doing that you should find the records leading to issues.
Your first statement would seem to indicate there is some kind of key clash going on, your second statement seems to indicate there is some kind duplicate item (source name, table name, field name) that is not expected.
+5
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
