topic Re: DOubt about MApping Table in QlikView

DOubt about MApping Table

nikhilgarg — Mon, 05 Jan 2015 06:50:29 GMT

Hey,

I have a question. Does the following true about ApplyMap () ??

1 ) No error if the mapping table does not exists. ??

2) Mapping table exists after LOAD ??

Thanks

Re: DOubt about MApping Table

its_anandrjs — Mon, 05 Jan 2015 06:53:34 GMT

Hi,

1. Yes no error prompt in case Mapping table not exists in the model.

2. Mapping Table should be loaded first before apply map to the table.

Regards

Anand

Re: DOubt about MApping Table

amit_saini — Mon, 05 Jan 2015 07:03:01 GMT

Hi Nikhil,

Yes no error if the mapping table doesn't exist.
Mapping should be before load.

For example purpose please see the attachment.

Thanks,
AS

Re: DOubt about MApping Table

Mon, 05 Jan 2015 07:03:42 GMT

Hi Nikhil,

1) .No error message is generated when Mapping Table is not found /exists.

2) Mapping Table does not exist after Reload...i.e Mapping Table will not be shown in your Table Structure(Ctrl+T).

Regards,

Ankur

Re: DOubt about MApping Table

Anonymous — Mon, 05 Jan 2015 07:10:25 GMT

Hi Nikil,

If u need some error prompt for mapping table you can add an third parameter which returns ur defined custom value like num,string,etc if the matching table doesn't exist.

ex: Applymap('Bonus','Empcode',0)

If there is no mapping table Bonus it wil throw 0 .

Thanks

Re: DOubt about MApping Table

Anonymous — Mon, 05 Jan 2015 07:11:30 GMT

Hope this will hepl you Apply map

Re: DOubt about MApping Table

nikhilgarg — Mon, 05 Jan 2015 07:17:41 GMT

HEy,

But i use applymap with a mapping table name and a column but it gives me error.

Re: DOubt about MApping Table

nikhilgarg — Mon, 05 Jan 2015 07:17:45 GMT

HEy,

But i use applymap with a mapping table name and a column but it gives me error.

Re: DOubt about MApping Table

nikhilgarg — Mon, 05 Jan 2015 07:17:49 GMT

HEy,

But i use applymap with a mapping table name and a column but it gives me error.

Re: DOubt about MApping Table

nikhilgarg — Mon, 05 Jan 2015 07:17:53 GMT

HEy,

But i use applymap with a mapping table name and a column but it gives me error.

Re: DOubt about MApping Table

Anonymous — Mon, 05 Jan 2015 07:26:24 GMT

Hi ,

Can you post your sample data

Re: DOubt about MApping Table

Mon, 05 Jan 2015 07:37:27 GMT

Hi Nikhil,

Can you share the error details...and Syntax for Applymap is as follows:

APPLYMAP('Mapping_Table_Name',FieldName,'Default Value') AS [Required Field]

Note: Mapping Table Name must be enclosed with single qoutes.

regards,

Ankur

Re: DOubt about MApping Table

NareshGuntur — Tue, 06 Jan 2015 07:36:02 GMT

Hey Nikhil,

Can you post the error you get?

Cheers,

Naresh

Re: DOubt about MApping Table

nikhilgarg — Tue, 06 Jan 2015 07:41:28 GMT

HEy,

Actually i again tried it and does not get any error . Rather i get a column added with null values.

So no error is there.