Mapping Load

[dunnalahk123]

Hi,

Can some one help me here for mapping load and apply map

i am writing script as below,

MAP:

mapping LOAD

[PSA Project pse Project ID],
[HOLD Closure date2]  
 
FROM
[$(QVD_Path)\GSD_HOLDClosuredate2.qvd]
(qvd);

HOLD:

LOAD

     [PSA Project pse Project ID],
     [HOLD Closure date],
    Applymap('MAP', [PSA Project pse Project ID],[HOLD Closure date2]) as T

FROM
[$(QVD_Path)\GSD_HOLDClosuredate.qvd]
(qvd);

out put i got as below,

but here one Project ID  can have multiple dates, but when i wrote apply map for "T" column  2 rows dates are coming same which it should not be. it should come one date as 08/16/2017 and second date as 09/29/2017. as shown in second snapshot.

can some one help me here.

[dunnalahk123]

Hi Sunny,

Really you are superb always  . Thanks a lot .   🙂

Best Regards,

HK

[Anonymous]

Hi Sunny,

Can you let me know why 1 is appended in Mapping and 2 in the Hold?

[Anonymous]

Hi Sunny,

Can you throw some light what went wrong in the above script and what is the purpose of adding 1 and 2 at the end ?