Need Help on ApplyMap

[alvinford]

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.

[vgutkovsky]

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

[alvinford]

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.

[brindlogcool]

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

[vgutkovsky]

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

[#6]

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.

[#7]

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.

[#8]

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.

[#9]

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.

[alvinford]

Hi Vlad,

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

Thanks in Advance.

Regards,

Alvin.