Eliminate Duplicate Records

[#1]

Hi:

LOAD A,

     B,

     C,

     D,

     E,

     F,

     G

FROM

C:\Users\QVCONS\Desktop\DATA.txt

(txt, codepage is 1252, embedded labels, delimiter is ',', msq)

WHERE NOT EXISTS(*);

But it is not working.

My intentions is to write all the columns. Is there any shortcut ?

[sujeetsingh]

Can you post asample

[swuehl]

Have you tried a

LOAD DISTINCT ...

without the WHERE clause?