Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good morning All,
I was wondering if someone could assist with how I could adjust my load statement so that it replaces certain values in a field when doing the upload. I have a field which has contains the values Poor, Good, Average and "-". The "-" represents a situation where an evaluation hasn't yet been done. I would like to replace this "-" with some text, "Incomplete". How would I add this to the upload statement, say the field is called 'Assessment'.
Thank you
Herbiec09
If the field's name is Assessment,
in the load script:
Load
if( Assessment='-','Incomplete',Assessment) as Assessment,
field2,
field3,
...
from table ;
Hope this helps
MC
If the field's name is Assessment,
in the load script:
Load
if( Assessment='-','Incomplete',Assessment) as Assessment,
field2,
field3,
...
from table ;
Hope this helps
MC
Hi,
Try this,
Load *,
if( Assessment='-','Incomplete',Assessment) as NewAssessment
from table;
Use NewAssessement for use
Regards,
Perfect solution, many thanks
Much appreciated
Something like this?
Temp:
Load * Inline
[
Product, Quality
A, Good
B, Good
C, Poor
D, Average
E, -
F, -
G, Average
H, Poor
I, -
J, Average
];
NoConcatenate
Final:
Load
Product,
If(Quality = '-','Incomplete', Quality) as Quality
Resident Temp;
Drop Table Temp;