To fetch only one record in straight table

[veeranj]

Hi,

Below is the source data i have .

id	item	check
1	ABC	Y
2	DEF	Y
3	DEF	N
4	GHI	N
5	JKL	N
6	MNO	N
7	MNO	N
8	PQR	Y
9	PQR	N
10	PQR	N

I need output as

item	check
ABC	Y
DEF	Y
GHI	N
JKL	N
MNO	N
MNO	N
PQR	Y

As the above fields are  from different table ,can this be achievable in front end expression in straight table.

Thanks,

Anjee

[tresesco]

If you want to show unique records only, you can simply use a table box with those fields.

[Anil_Babu_Samineni]

What was the logic behind for duplicate items and getting check value.

[#4]

For DEF you have taken only one value 'Y'

and MNO you have both values 'N'.

Do you need first sorted Value or is there any other logic to show values.