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.