Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
If you want to show unique records only, you can simply use a table box with those fields.
What was the logic behind for duplicate items and getting check value.
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.