Show higher class

[hamzabob1]

Hii all,

I am new here and i have one question.

Invoice	Class	Required Output
1563489	First class Business class	First class
1543632	First class Economy class	First class
1673492	Business class Economy class	Business class

In the above example i have invoice_id and class.In some cases i have 2 class for one invoice id but i have to display only one class which has higher priority as i mention in required output field.please help me its urgent.

Thanks in advance

[swuehl]

I would start with defining the priority in the script:

LOAD Class, recno() as Priority INLINE [

Class

First class

Business class

Economy class

];

Then you should get what you want, e.g by using a chart with dimension Invoice and as expression

=FirstSortedValue( Class, -Priority)

[hamzabob1]

Thanks for your rpl..

but this is not wat i am looking for...

[Anonymous · Accepted solution]

PFA

[maxgro]

using Priority as previous suggestion

subfield(concat(Class, '@', Priority), '@', 1)

c:

load * inline [

Invoice, Class, Required Output

1563489, First class, First class

1563489, Business class, First class

1543632, First class, First class

1543632, Economy class, First class

1673492, Business class, Business class

1673492, Economy class, Business class

];

p:

LOAD Class, recno() as Priority INLINE [

Class

First class

Business class

Economy class

];

[#6]

Hi,

Please find the attached QVW file.

[hamzabob1]

Wow, super thanks to all.

Thanks