Change data value

[gerhardl]

Hi,

I have a field called [Decision Result]. Value would be eithe A or D.

How can I change my script to show A as "Approved" and D as "Declined"?

Thanks,

G

[suniljain]

if(Decision ='A','Active'.

if(Decision = 'D'.'Declined')) as Decision_Type

[pat_agen · Accepted solution]

hi,
there are many ways but the easiest is simply adding a new field (or replacing your existing field) like this

load

if( [Decision Result]='A','Approved',
if( [Decision Result]='D','Declined')) as [Decision Result]
....

if you have more complex transformations mapping tables are the way to go, look them up with the search facility.

hope this helps

[#4]

Hi

Try

if ( [Decision Result] = 'A', 'Approved', 'Declined') as [Decision Result],

Regards

Anders