topic Re: Character data to integer in QlikView

Character data to integer

Wed, 03 Jul 2013 11:47:06 GMT

Hi,

Can anyone help me in this

How can I change this IF statement as I need to get integer for eg: 23145 instead of 'Others'

IF(len(trim(name))=0 OR ISNULL(name)=-1,'Others',name) AS name_New

Thanks.

Re: Character data to integer

Wed, 03 Jul 2013 11:51:28 GMT

try this

if(

IF(len(trim(name))=0 OR ISNULL(name)=-1,'Others',name)='Others','23145'

)

or try this

if(

IF(len(trim(name))=0 ORISNULL(name)=-1,'Others',name)='Others','23145',

IF(len(trim(name))=0 OR ISNULL(name)=-1,'Others',name)

)

Re: Character data to integer

Wed, 03 Jul 2013 12:35:03 GMT

Hi,

It's not working can you please let me know a bit more clearer.

Re: Character data to integer

kaushiknsolanki — Wed, 03 Jul 2013 12:39:38 GMT

Hi,

I am not sure what exactly you are looking for.

Kindly explain with example.

Regards,

Kaushik Solanki

Re: Character data to integer

Wed, 03 Jul 2013 12:55:07 GMT

Actually

earlier I have fields which contains character data and the QVD is generated fine. Now That character is changed to integers as I need to generate Make tranformation and generate the QVD. as in the tranforamtion earlier it had been used

IF(WILDMATCH(xx,'abc*'),'abc',

IF(WILDMATCH(xx,'abc(ED)*'),'EDABC',xx)) AS xx_New

now I have data instead of 'abc*' integer data is there. how can I make WILDMATCH to integer data and also i need to generate this like below that means

How can I change this IF statement as I need to get integer for eg: 23145 instead of 'Others'

IF(len(trim(name))=0 OR ISNULL(name)=-1,'Others',name) AS name_New

Re: Character data to integer

kaushiknsolanki — Wed, 03 Jul 2013 13:27:39 GMT

amelia2000 wrote:
Actually
earlier I have fields which contains character data and the QVD is generated fine. Now That character is changed to integers as I need to generate Make tranformation and generate the QVD. as in the tranforamtion earlier it had been used

You can use the mapping load for changing your values from one form to another.

For more information look into help for mapping load. There is a good example too.

Now for

IF(len(trim(name))=0 OR ISNULL(name)=-1,'Others',name) AS name_New

Simply change the 'Others' to 23145

Regards,

Kaushik Solanki

Re: Character data to integer

Wed, 03 Jul 2013 13:39:08 GMT

Hi,

Earlier it contains character data that's why 'Others' is fine but noe there are so many integers like for eg: 12345, etc in this case how can I change? can you let me know.

Re: Character data to integer

kaushiknsolanki — Wed, 03 Jul 2013 13:46:32 GMT

Hi,

I guess it will be difficult to tell you unless you give some example of what was before and what is now with what exactly you are looking for.

Regards,

Kaushik Solanki

Re: Character data to integer

Wed, 03 Jul 2013 13:46:34 GMT

And as you said now to use mapping load in my case I don't have the table which contains character data it is earlier but now the entire character data is changed to integers in that how can I change?