show rows based on column

[rafael5958]

Hi, I want to show rows based in one column, if the row is the same as other, but just change becouse of one column value, keeps the greater lower value. I have a straight table:

name	value	type
AAAA	XXXX	1
AAAA	XXXX	3
AAAA	BBBB	4
FFFFF	GGGGG	2
FFFFF	GGGGG	3
XXXXX	FFFFFF	3

and need this:

name	value	type
AAAA	XXXX	1
AAAA	BBBB	4
FFFFF	GGGGG	2
XXXXX	FFFFFF	3

[lironbaram]

build a table 

use : name and value as dimensions 

and min(type) as expression 

[Kushal_Chawda]

try below

Load name,
     value,
     min(Type) as Type
FROM table
group by name,value;

[Taoufiq_Zarra · Accepted solution]

if i understood correctly

Dimension: name and value

Measure : min(type)

output :

if not can you elaborate ?

[Brett_Bleess]

@rafael5958 You have received multiple replies, we would appreciate it if you would return to the thread to close it out by using the Accept as Solution button on the post(s) that helped you resolve things.  If you need further help, please be sure to leave an update on what you still need, and if you did something different, you can post what you did and then mark that post using the button as well, but I would in that case use the Like feature on any other posts that did help you with things.

Regards,
Brett