topic Re: Generating data in a load statement in QlikView

Generating data in a load statement

Wed, 19 Mar 2014 09:11:24 GMT

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

Re: Generating data in a load statement

Wed, 19 Mar 2014 09:19:51 GMT

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

Re: Generating data in a load statement

PrashantSangle — Wed, 19 Mar 2014 09:36:25 GMT

Hi,

Try this,

Load *,

if( Assessment='-','Incomplete',Assessment) as NewAssessment

from table;

Use NewAssessement for use

Regards,

Re: Generating data in a load statement

Wed, 19 Mar 2014 09:38:34 GMT

Perfect solution, many thanks

Much appreciated

Re: Generating data in a load statement

MK_QSL — Wed, 19 Mar 2014 09:39:34 GMT

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;