topic Re: Breaking Intervals in QlikView

Breaking Intervals

Thu, 16 Apr 2015 06:17:07 GMT

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

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

Table B

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!!

Re: Breaking Intervals

swuehl — Tue, 14 Jul 2015 17:37:30 GMT

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;

Re: Breaking Intervals

ramoncova06 — Tue, 14 Jul 2015 18:40:54 GMT

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

Re: Breaking Intervals

Mon, 10 Aug 2015 09:32:39 GMT

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.