first element in a filed

[#1]

hi,

what's the name of the function that returns the first element in a filed? for example, in the data i have:

sku #	sku name
1	a
1	a
2	b
2	b

and in the straight table i want to get:

sku # (dimension)	sku name (expression)
1	a
2	b

i know that i can achieve this by simply add "sku name" as a second dimension, but i want "sku name" to be a calculated expression.

any ideas?

thanks

[jerem1234]

Try just skuName as expression or maybe only(skuName).

Do your sku #'s have multiple sku names? or are they all a for 1, b for 2, etc?

Other function that may help is firstsortedvalue() if those dont work.

Hope this helps!

[#3]

they are all a for 1, b for 2, etc... i tried your 3 alternative but it doesn't seems to work...

thanks

[jerem1234]

Maybe try maxString(skuName).

Else, could you post a sample qvw that demonstrates your problem?

[#5]

thanks you jerem.

[Josh_Good]

Using just Sku Name works for me in this example.