Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
upper(Pi) as Pi;
upper(Pi) as Pi;
Just use Upper() function
LOAD Upper(Pi) as Pi,
....
Thanks