topic Re: Default Value Option in Inline in QlikView

Default Value Option in Inline

Tue, 24 Jul 2012 19:17:58 GMT

Hi,

I have below table which describe various grocery types-

Name	Qty	Season	Country of Origin
Mango	2	Spring	Mexico
Orange	3	All Seasons	USA
Apple	4	All Seasons	USA
Fig	2	Winter	Italy
Rice	3	Summer	China
Peppers	5	All Seasons	Jamaica

I am creating inline table to attach field Type. I want to have Types as "Fruit","Crop" or "Unknown".

Load * Inline

[

Name,Type

Mango,Fruit

Orange,Fruit

Apple,Fruit

Fig,Fruit

Rice,Crop

]

Now in above list I want to add a default option which will map any other 'Name" value as "Misc".

Can you please suggest how to check it.

Re: Default Value Option in Inline

MayilVahanan — Tue, 24 Jul 2012 19:44:01 GMT

HI,

Use

Test:

Mapping Load * Inline

[

Name,Type

Mango,Fruit

Orange,Fruit

Apple,Fruit

Fig,Fruit

Rice,Crop

];

Load *, ApplyMap('Test',Name ,'Misc') as FieldName from tablename;

Hope it helps

Re: Default Value Option in Inline

Tue, 24 Jul 2012 21:11:37 GMT

Hi Mayil,

Which table name you are expecting in below line?

Load *, ApplyMap('Test',Name ,'Misc') as FieldName from tablename;

Re: Default Value Option in Inline

MayilVahanan — Tue, 24 Jul 2012 21:15:32 GMT

HI,

Below table which describe various grocery types, you specified know-Please use that table ..

Edit:After use that, let me know, its working?

Hope it helps

Re: Default Value Option in Inline

Tue, 24 Jul 2012 21:23:34 GMT

Thanks a lot for all the help. I will try this option.

Re: Default Value Option in Inline

Tue, 24 Jul 2012 21:51:59 GMT

Ok did something like this..

Grocery_Table:

[Name,Qty,Season,Country Of Origin]

Test:

Mapping Load * Inline

[

Name,Type

Mango,Fruit

Orange,Fruit

Apple,Fruit

Fig,Fruit

Rice,Crop

];

Load *, ApplyMap('Test',Name ,'Misc') as Type

Resident Grocery_Table;

Thanks Mayil without your advice it was not possible.