Changing field values in the LOAD script

[Anonymous]

I have a field called 'Pi' which has values 'Yes' or 'No'.  Is there a way to LOAD the data into Qlikview but change all 'Yes' value to 'YES' and all 'No' value to 'NO' from the LOAD script?

Thanks

Greg

[m_woolf · Accepted solution]

upper(Pi) as Pi;

[sunny_talwar]

Just use Upper() function

LOAD Upper(Pi) as Pi,

           ....

[Anonymous]

Thanks