Breaking Intervals

[#1]

I have 2 data sets one have the date+interval records against each ID and there is another file that also have the same data in the same format. Now i want to join let's say table A to the table B wherein both the intervals are different. Now while i am able to break the date and time into time intervals but not able to join due to non unique data. Can somebody please help me to get out of this asap.

This is the sample data-

Table A

Login ID      Start Time                          End Time

2222          04/15/2015 09:45:00 AM      04/15/2015 10:55:00 AM

Table B

Login ID      Start Time                          End Time

2222          04/15/2015 10:05:00 AM      04/15/2015 10:15:00 AM

Let me know just in case the inputs are not sufficient.

Thanks!!

[swuehl]

You will be able to join on Login ID  if you rename the Start Time and End Time fields in TableB, like

LOAD

     LoginID,

     StartTime,

     EndTime

From TableA;

JOIN

LOAD

     LoginID,

     StartTime as StartTimeB,

     EndTime as EndTimeB

From TableB;

[ramoncova06]

is the reason why you want to join is because you need to include other fields ?

if you want o create another entry then you should use concatenate instead of joining the data

[#4]

what i am looking is as follows -

If i am selecting date (1 Jan 15) then i should be getting the data from both the tables by the intervals.

if this can be resolved, it would be a great help. i am still using it in QV but it cannot be an automation, i am doing it manually in QV till now.