Concatenate two objects

[dunnalahk123]

Hi,

can some one help me here for below scenario

i have two objects  which i am concatenating

HOLD:

LOAD [Project ID],
     [HOLD Closure date],
     //[HOLD Closure date2],
//     Field_Text,
//     Old_Value_Text,
//     New_Value_Text,
     [PSA Project pse Project ID]
   
FROM
[$(QVD_Path)\GSD_HOLDClosuredate.qvd]
(qvd)

;

Concatenate

LOAD [Project ID],
     //[HOLD Closure date],
     [HOLD Closure date2],
//     Field_Text,
//     Old_Value_Text,
//     New_Value_Text,
     [PSA Project pse Project ID]
      
FROM
[$(QVD_Path)\GSD_HOLDClosuredate2.qvd]
(qvd);

From above you can see i am getting output in 4 lines but i need it in 2 lines.

can some one suggest me here.

Best Regards,

Hari

[dunnalahk123]

Hi,

map1:

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('map1', [PSA Project pse Project ID],'unknown') as T
FROM
[$(QVD_Path)\GSD_HOLDClosuredate.qvd]
(qvd);

But Second field "T" is coming same date for both 2 rows. which it should not be as per below snashot

[dunnalahk123]

Hi,

As per Apply map function properties in serves data in first come first serve order.

But what to do if there are different value for same id

And how to get the second referring value for the same.

[neelamsaroha157]

The thing is that system doesn't know which Closure date corresponds to Closure date2 and its creating four rows.

If you have a logic to say that 9/20 should be placed against 9/29 or 8/16 then it may work.