Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
can any please help
Hi,
Use below as your sort string expression.
Dual("Your Field",match("YourField" ,'synergis','ethics','oncology','promot','ptc'))
Regards
ASHFAQ
You can use a dual load, use a mapping load foor the product order first. See attached
More about Dual:
How to use- Dual()
hi i have tried but not working
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
Kindly Let me know .if its working or not?
Not working
u r from
Hi can you post your application
