topic Re: Need Help on ApplyMap in QlikView

Need Help on ApplyMap

alvinford — Wed, 12 Dec 2012 15:26:57 GMT

Hi All,

Struck up with the following issue and need your help.

The Terrm Start Date have the following values.

TermStartDate

01/01/2010

01/05/2012

01/01/2013

I am using the following code to get the TermStartDate Values into the Table ABC.

TermStart:

Mapping Load
Key,
TermStartDate
Resident TempTable;

ABC:

Load

Key,

Applymap

('TermStart',Key,Date) as TermStartDate,

Country,

Status

from Employee.Qvd;

But I am getting only one value . How could I resolve this problem.

TermStartDate

01/05/2012

Regards,

Alvin.

Re: Need Help on ApplyMap

vgutkovsky — Wed, 12 Dec 2012 15:30:47 GMT

It's probably defaulting to the 3rd parameter, Date. Check to make sure that your key has a match in both tables and that it's in the same format in both (i.e. either text in both or numeric).

Regards,

Vlad

Re: Need Help on ApplyMap

alvinford — Wed, 12 Dec 2012 15:54:50 GMT

Hi Vlad,

I have checked the Key and the Date Format, They are correct . Its combination of text and Numeric. Is there any other reason that leads to this issue .

Regards,

Alvin.

Re: Need Help on ApplyMap

brindlogcool — Wed, 12 Dec 2012 16:00:34 GMT

I think It is defaulting the date value.can you attach the file. It would be easier to identify the root cause

Re: Need Help on ApplyMap

vgutkovsky — Wed, 12 Dec 2012 16:04:48 GMT

There are potentially several reasons this can happen. Can you post a reduced example?

Re: Need Help on ApplyMap

Wed, 12 Dec 2012 16:13:28 GMT

Please can you check the values in the Key used in the mapping table. Sometimes the value in the Key will be same and the first record from the apply map will be displayed.

Re: Need Help on ApplyMap

Wed, 12 Dec 2012 16:13:38 GMT

Please can you check the values in the Key used in the mapping table. Sometimes the value in the Key will be same and the first record from the apply map will be displayed.

Re: Need Help on ApplyMap

Wed, 12 Dec 2012 16:13:56 GMT

Please can you check the values in the Key used in the mapping table. Sometimes the value in the Key will be same and the first record from the apply map will be displayed.

Re: Need Help on ApplyMap

Wed, 12 Dec 2012 16:14:24 GMT

Please can you check the values in the Key used in the mapping table. Sometimes the value in the Key will be same and the first record from the apply map will be displayed.

Re: Need Help on ApplyMap

alvinford — Wed, 12 Dec 2012 16:34:00 GMT

Hi Vlad,

I have attached the required QVD and Sample Application. Reuest your help.

Thanks in Advance.

Regards,

Alvin.

Re: Need Help on ApplyMap

alvinford — Wed, 12 Dec 2012 16:40:11 GMT

Hi Vlad,

Please Refer the Attached Sample. I have selected the discussed example .

Regards,

Alvin.

Re: Need Help on ApplyMap

vgutkovsky — Wed, 12 Dec 2012 16:51:16 GMT

I think I understand now. Are you saying the problem is that your mapping table only maps in 1 of multiple values on the key? That's how a mapping table works. If you have multiple values, you will either need to use a join or create a linked table.

Regards,

Vlad

Re: Need Help on ApplyMap

alvinford — Wed, 12 Dec 2012 16:59:47 GMT

Hi Vald,

Thanks for the Reply. If I use the left join the Number of rows are increasing and not getting the desired resuls.

As I have some further calculations I have to maintain in only one table can't go for a link table .

Regards,

Alvin.

Re: Need Help on ApplyMap

vgutkovsky — Wed, 12 Dec 2012 17:03:55 GMT

I would suggest going with the linked table approach. If your script has further calculations that require all fields to be in the same table, you can create a temporary table where you join the other tables together and then use GROUP BY and DISTINCT to get rid of any duplication in this temporary table.

Vlad

Re: Need Help on ApplyMap

ngulliver — Mon, 17 Dec 2012 13:14:54 GMT

Hi,

I would recommend having a look at Steve's blog:

http://www.quickintelligence.co.uk/applymap-is-it-so-wrong/

This is very helpful in explaining Apply Map.

Neil