Match cases

[noman212]

Hi all,

i have values  in data bases 'Y','D','I' and so on i want to display on selection if i select Y then textbox show 'Premium' if D then it becomes difference.how can i do this?please tell

[noman212]

M USING THESE TABLES

[Anonymous]

Just a thought,not sure this is what the issues,

Rename all your NPH_Code like below in all the tables

NPH_Code as NPC

[ashfaq_haseeb]

Hi noman,

you can use pick and match as shown below.

LOAD *,pick(Match(NPH_PRIMUS,'A', 'D', 'E','I','Y'), 'Premium', 'Difference','Ultra','ISO','Super' ) AS DESCRIPTION;

Load * inline

[

NPH_PRIMUS

A

D

E

I

Y

];

Regards

ASHFAQ