Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have a simple table with two fields and I don't want to see the data from this table if it is included in other data. Is this possible? How we can script group by? Thank you.
ID | Name and Surname |
756821 | John Perkıns |
756821 | John Perk |
756821 | Eva Jahnson |
756821 | Hılarry Sntk |
894345 | Kafn Terns |
894345 | Kafn Terns.wes |
894345 | Lında Terrace |
I want to result:
ID | Name and Surname |
756821 | John Perk |
756821 | Eva Jahnson |
756821 | Hılarry Sntk |
894345 | Kafn Terns |
894345 | Lında Terrace |
You may apply one of the below options:
load ID,
firstvalue([Name and Surname]) as FirstValue,
maxstring([Name and Surname]) as MaxString,
minstring([Name and Surname]) as MinString
from X group by ID;