Qlik Community

Ask a Question

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Duplicate rows (need new table)

Hi, i have a table like this:

idfield1field2
a1dat1f1
a1dat11f1
a1dat111f1
a2dat2ta2
a2dat2ta22
a3dat3f3
a4dat4f4
a4dat44f4

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

id
a1
a2
a3
a4

thanks!!!

2 Replies
Not applicable

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

     id

Resident Table;

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

Brg

//KArathorn

What are you trying to achieve by that?

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