topic Re: Load all the repeated rows in App Development

Load all the repeated rows

lmenendez_grupo_pinero — Thu, 31 Mar 2022 12:53:12 GMT

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,

Re: Load all the repeated rows

justISO — Thu, 31 Mar 2022 13:15:42 GMT

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);

Re: Load all the repeated rows

lmenendez_grupo_pinero — Thu, 31 Mar 2022 13:57:57 GMT

Hi,

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

Regards

Re: Load all the repeated rows

justISO — Thu, 31 Mar 2022 14:51:33 GMT

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