topic change data in a load in QlikView

change data in a load

Mon, 29 Oct 2012 09:14:42 GMT

I´ve got a field [SEX] with the data F or M (female or male).

I want to change the F to a W.

Is this or something like this the way

LOAD [SEX],

IF [SEX]=F then W as SEXa;

Or maybe someone have a better solution??

Re: change data in a load

fdelacal — Mon, 29 Oct 2012 09:29:55 GMT

LOAD [SEX],

IF ([SEX]= 'F','W') as SEXa;

trie with this.

Re: change data in a load

MayilVahanan — Mon, 29 Oct 2012 09:31:02 GMT

try like this

load *,if(sex='f','w',sex) as sex from tablename;

hope it helps

Re: change data in a load

Mon, 29 Oct 2012 09:33:39 GMT

Hi,

You can use the Mapping and Applymap() Concept.

Please refer these two from Qlikview help menu.

Regards,

Kabilan K.

Re: change data in a load

Mon, 29 Oct 2012 09:35:23 GMT

Hi Kabilan

Could you please make an example

Regards

Re: change data in a load

Mon, 29 Oct 2012 09:35:32 GMT

Hi,

LOAD [SEX]

IF([SEX]='F',[SEX]) as SEXa;

Regards,

Prasath

Re: change data in a load

Mon, 29 Oct 2012 09:37:47 GMT

LOAD [SEX],

IF [SEX]=F then W as SEXa;

should be

LOAD [SEX],

IF ([SEX]='F','W') as SEXa;

The field SEXa will have the value W when it was F. It will have a NULL value when it is NOT W... (meaning there is no else defined in the if clause)

Please check the if/else syntax; it is pretty basic ;--)

Re: change data in a load

Mon, 29 Oct 2012 09:37:58 GMT

Hi..

U can use below script....

MapTable:

Load * Inline

[Text, AltText

F,W];

LOAD [SEX],

Applymap('MapTable',[SEX]) as SEXa;

Hope this helps u.

Regards,

Kabilan K.

Re: change data in a load

Mon, 29 Oct 2012 10:04:07 GMT

Hi Kabilan,

Below is the example

a:
Mapping
LOAD * INLINE [
Current, Changed
F,W
];

b:
LOAD * INLINE [
    Sex, Name
    M, Kim
    F, Ruchi
    M, David
    F, Kathe
];
c:
NoConcatenate
LOAD Name, ApplyMap('a',Sex) as Se
Resident b;
drop Table b;