Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey,
I have a data set which solely consists of 0 and 1. On loading, I want those numbers to be converted into string information: 0 = High and 1 = Low
It should go into the following direction:
LOAD
DATA
if ( DATA = 0, "High", DATA) OR if( DATA= 1, "Low", DATA) as NewDATA
I would appreciate your help.
Martin
Hi
use the following:
If(DATA = 0, 'High', 'Low') As NewDATA
Regards
Jonathan
Hi
use the following:
If(DATA = 0, 'High', 'Low') As NewDATA
Regards
Jonathan