Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all ,
i have incidents, changeorders .
Incident:
Load* inline [
InNo, Opendatetime,CIName
123,11/4/2017 12:00:00 AM, Keyboard
124,11/4/2017 02:00:00 AM,Mouse
125,11/4/2017 2:00:00 AM,laptop
];
Similarly
Changeorder:
CRNo, scheduleddatetime,CIName
CR123,11/4/2017 12:00:00 AM, Keyboard
CR124,11/4/2017 02:00:00 AM,Mouse
CR 125,11/4/2017 2:00:00 AM,laptop,
CR 125,11/4/2017 2:30:00 AM,Speaker,
CR 125,11/4/2017 2:00:00 AM,Memorcard,
CR 125,11/4/2017 3:00:00 AM,laptop
];
Now my requirement is need create a staright table as based on Same CINames
How many Incidents are opened during the changeorders scheduleddatetime.
i want be in this format
can anyone helpplease