reg-sorting

[#1]

Hi Team

I have to sort the product in the straight table ;

i have products like synergy,ethics,oncolog,promot,ptc

in my previous UAT i have in correct format but in the prod the order is misplaced and it was ethics

                                                                                                                                     synergy

                                                                                                                                     oncology

                                                                                                                                     promot

                                                                                                                                     ptc

i have done  Ascending and given order ,and text also in Ascending.

but also iam getting wrong

i want to display my products in my production file like  synergis

                                                                                 ethics

                                                                                 oncology

                                                                                 promot

                                                                                 ptc

can any please help

[ashfaq_haseeb]

Hi,

Use below as your sort string expression.

Dual("Your Field",match("YourField" ,'synergis','ethics','oncology','promot','ptc'))

Regards

ASHFAQ

[stigchel]

You can use a dual load, use a mapping load foor the product order first. See attached

[robert_mika]

More about Dual:

How to use- Dual()

[#5]

hi i have tried but not working

[nagarjuna_kotha]

Hi

Try this,

It should work exactly .

Goto Sort Tab>>Select Your Field>>Enable Expression>> Add below Expression.

=Wildmatch('Your Field ','ETHICAL','DIABETES','ONCOLOGY','PROMOTED ','CHC')

Regards,

Nagarjuna

[nagarjuna_kotha]

Hi,

Kindly Let me know .if its working or not?

Regards,

Nagarjuna

[#8]

Not working

[#9]

u r from

[ashfaq_haseeb]

Hi can you post your application

Regards

ASHFAQ