Load all the repeated rows

[lmenendez_grupo_pinero]

Hi,

I have to load a 'csv' table whith 40 fields , many rows are equal in all their fields.

To avoid not to load all de rows I allwais use the function Row() as row identification but for a reason I do not nknow is not 100% secure to load all rows.

Does it exist a better way to be 100% sure to load 100% off all the repeated rows?

Thank you,

[justISO]

Hi, in load script add 'distinct' to load only unique rows by any field, like this:

LOAD distinct
*
FROM [lib://AttachedFiles/YOUR.csv] (txt, utf8, embedded labels, delimiter is ',', msq);

[lmenendez_grupo_pinero]

Hi, 

thanks but is just the opposite result that I'm looking for , I want all the original rows despite they are repeated.

Regards

[justISO · Accepted solution]

You always load ALL rows of table/file if you don't use any 'where' clause or filtering.