Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi Sunny,
Really you are superb always . Thanks a lot . 🙂
Best Regards,
HK
Hi Sunny,
Can you let me know why 1 is appended in Mapping and 2 in the Hold?
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 ?