deleting duplicate rows from dataset

[reddy19]

Hi,

I'm exploring enterprise guide...I would like to know how to eliminate duplicate records from external file (XL or CVS).

And also how would i delete entire row if one colum is empty using EG 4.1.

Thanks,
reddy

[ChrisHemedinger]

You can easily do this with the Query Builder. Specify the columns you want, tick the box to get "distinct" records only, and set a filter to eliminate values that are MISSING (or NULL, as I think was used in the 4.1 query builder terminology).

The output table would have the result you want.

Chris

[reddy19]

Hi Chris,

I'm able to take distinct records from the table...could you please explain in detail about applying filter for missing values,

Thanks,
Reddy

[SASuserxx]

Hi CHris,

how do you set filter to 'eliminate value'? 

im using eg 5.1 and trying to delete duplicate in my dataset

[reddy19]

Thanks Chris.

Finally i'm able to figure it out.

[coba]

How did you manage?