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.

[alvinford]

Hi Vlad,

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

Regards,

Alvin.

[vgutkovsky]

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

[alvinford]

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.

[vgutkovsky]

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

[ngulliver]

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