topic Re: Duplicate rows (need new table) in QlikView

Duplicate rows (need new table)

Fri, 07 Jun 2013 15:22:14 GMT

Hi, i have a table like this:

i need join wiht itself (a new table) but only takes a unique id, like this:

thanks!!!

Fri, 07 Jun 2013 21:18:53 GMT

Load Distinct

id,

field1,

field2

Resident Table;

but with the data U show all rows will be in the new table.

So if u need atable as shown in the example the story goes like this:

Load Distinct

Resident Table;

The u will have separate table with only unik values in filed id.

Brg

//KArathorn

CELAMBARASAN — Sat, 08 Jun 2013 05:59:55 GMT

What are you trying to achieve by that?

If you explain explain little more clear it is easier to give you a better solution.