Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
I am trying to get distinct values from a table.
| ID | Kind | Type |
| 1 | CFF | ABC |
| 1 | CFF | ABC |
| 1 | CFF | ABC |
| 2 | EMI | IRL |
| 2 | EMI | IRL |
| 3 | CFF | ABC |
| 4 | CCS | SEV |
| 4 | CCS | SEV |
| 5 | DEP | - |
| 6 | FX | - |
| 6 | FX | - |
I am trying to get distinct value of ID, Kind and Type like in this following table:
| ID | Kind | Type |
| 1 | CFF | ABC |
| 2 | EMI | IRL |
| 3 | CFF | ABC |
| 4 | CCS | SEV |
| 5 | DEP | - |
| 6 | FX | - |
Thank you for your help in advance!
use Rowno() in script and call same in table and hide this field
Thank you for the suggestion but I am not clear what you want me to do.
I need to get the modified table in the script without using frontend tools since I still need to work on it for other tasks.