Non distinct of entries

[renjithpl]

hi all,

i have duplicate line items like below,

Date SerialNo Dollar refernceno

01-02-02	00006369068	40.00	S	X2001601
01-02-02	00006369068	40.00	S	X2001601

the problem is when i load it and displayed it in straight table it is showing in one line item, i dont want distinct.

i want to show as two entries.

any possible ways ?

thanks

[#2]

Hi Ranjit,

there are some ways:

- using a straight table QV will always show only one distinct line for duplicate rows. A straight table is a kind of chart and there this is a expected behavior. So If you want for some reasons using a stright table you will need a unique key field to make your rows distinct (i.e. using rowno() during load)

- otherwise use a tablebox. It shows the data as it is in the table.

HtH

Roland

[johnw]

Roland Kunle wrote:otherwise use a tablebox. It shows the data as it is in the table.

A tablebox will only show you the distinct combinations of field values as well. It is not a row-by-row table viewer.

So a unique key as a dimension is probably the best option. If you don't want to see it in the straight table, go to the presentation tab and hide that dimension.

[renjithpl]

thanks guys, i will use a unique key and hide it in the straight table.

[renjithpl]

hi john,

I got the result in my straight table, now i want to highlight duplicate line items . how can i do that..?

Please help me..

[#6]

[quote user="John Witherspoon]

Ho John,

thanks for your information. So there is no object to see "the point of truth" unless your table still has or you create a unique key. I am working for a while with QV and it seems that I always had them (lucky!).

Regards, Roland