First value for specific id with multiple same values

[v_ganchev]

Hello.
Here is the scenario.

ID	Value
1	Value Text
1	Value Text
1	Value Text
1	Not Wanted Value Text

The question is how to see like this table:

ID	Value
1	Value Text

Always there is a multiple the same ID.
Every single ID have multiple values, only the last value is different.
I need to get only Value Text, which is text.
The last value is text that I don't need.

[sunny_talwar]

So, you want to do this in the script and you only want a single row with the value text which is not associated with the last row?

[v_ganchev]

Yes. I was trying from the table chart but didn't success.

[Gabriel]

Hi,

My question is, would you always know the value you wish to exclude?

If the answer is yes, then in your UI you can exclude the value using 

COUNT({<Value -={'Not Wanted Value Text'}>} ID)

And in script use 

tmp:
LOAD * INLINE [
ID, Value
1, Value Text
1, Value Text
1, Value Text
1, Not Wanted Value Text
](delimiter is ',')
WHERE NOT MATCH(Value,'Not Wanted Value Text');

Let us know if this helps

[sultanam]

Hi,

If you only want to load first value then use below code

LOAD ID,
firstvalue(Value) as Value
FROM
Source group by ID;

Regards,
Sultan