Qliksense Load Group by in name

[krmvacar]

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

[marcus_sommer]

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;