topic Re: change values in the field in QlikView

change values in the field

arulsettu — Wed, 05 Feb 2014 06:52:20 GMT

i have a field like this

instead of S and I i have to display store and individual ho can i do that? thanks.....

Re: change values in the field

preminqlik — Wed, 05 Feb 2014 06:56:38 GMT

This can be done in backend and front end

in backend

if(Customer='S','Store',if(Customer='I','Individual','Others') as NewFieldName

or you can do by applymap

in front end

if(Customer='S','Store',if(Customer='I','Individual','Others')

Re: change values in the field

senpradip007 — Wed, 05 Feb 2014 07:01:19 GMT

Hi arul.

Mr Prem is right. You can try this.

Re: change values in the field

arulsettu — Wed, 05 Feb 2014 07:03:26 GMT

Customer is table name?

Re: change values in the field

Wed, 05 Feb 2014 07:04:33 GMT

try this

in expression--

pick(match(CustomerTy,'S','I'),'store','indivisual')

**********************************************

in script

pick(match(CustomerTy,'S','I'),'store','indivisual') as Customer

Re: change values in the field

preminqlik — Wed, 05 Feb 2014 07:08:53 GMT

This can be done in backend and front end

in backend

if(CustomerTy='S','Store',if(CustomerTy='I','Individual','Others') as NewFieldName

or you can do by applymap

in front end

if(CustomerTy='S','Store',if(CustomerTy='I','Individual','Others')

and try Vishwaranjan Kumar solution its a better approach...

Re: change values in the field

er_mohit — Wed, 05 Feb 2014 07:14:46 GMT

You can use mapping load for that

like this

Type:

mapping LOAD * INLINE [

CustomerType,FullName

S,Store

I,Individual

];

Map CustomerType using Type;

LOAD * INLINE [

CustomerType

];

Re: change values in the field

arulsettu — Wed, 05 Feb 2014 07:15:56 GMT

if(CustomerType='S','Store',if(CustomerType='I','Individual') as new;

hi it throw script error.. did i made any mistake?

Re: change values in the field

rsdhavle — Wed, 05 Feb 2014 07:18:40 GMT

You can use applymap() function which will work as lookup for you and it would be a good approach

Re: change values in the field

arulsettu — Wed, 05 Feb 2014 07:21:48 GMT

it display like this in script it says error.. thanks...

Re: change values in the field

senpradip007 — Wed, 05 Feb 2014 07:22:44 GMT

Use , instead of ;

Re: change values in the field

MK_QSL — Wed, 05 Feb 2014 07:26:04 GMT

Load below table first..

Mapping_Table:

Load * Inline

[

Type, Name

I, Indivisual

S, Store

];

Now in the table where your CustomerType is there... use below

ApplyMap('Mapping_Table',CustomerType) as TypeName,

Hope this help..

Re: change values in the field

arulsettu — Wed, 05 Feb 2014 07:32:52 GMT

Hi Manish

applymap throws script error... thanks..

Re: change values in the field

MK_QSL — Wed, 05 Feb 2014 07:36:40 GMT

Can you upload your file or sample data?

Re: change values in the field

senpradip007 — Wed, 05 Feb 2014 07:39:49 GMT

can you upload your script or sample file?

Re: change values in the field

MK_QSL — Wed, 05 Feb 2014 07:40:22 GMT

Sorry, Mapping Word was missing in Mapping Load Table...

Re: change values in the field

MK_QSL — Wed, 05 Feb 2014 07:40:55 GMT

it should be

Mapping_Table:

Mapping Load * Inline

[

Type, Name

I, Individual

S, Store

];

Now in the table where your CustomerType is there... use below

ApplyMap('Mapping_Table',CustomerType) as TypeName,

Re: Re: change values in the field

arulsettu — Wed, 05 Feb 2014 07:42:18 GMT

hi i attached the file

Re: change values in the field

MK_QSL — Wed, 05 Feb 2014 07:45:00 GMT

Try enclosed file now...

Re: change values in the field

MK_QSL — Wed, 05 Feb 2014 07:47:22 GMT

You can use like below also...No need for Mapping Load

ODBC CONNECT32 TO [MS Access Database;DBQ=E:\sample database\AdventureWorks.accdb];

Load CustomerID,

IF(CustomerType = 'S', 'Store',

IF(CustomerType = 'I', Individual)) as CustomerTypeFull;

SQL SELECT CustomerID,

CustomerType

FROM `Sales_Customer`;