Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Friends,
Here i have two tables.
In Table A, there are some part no. with different created date and task no.
In Table B, there are some part no. with different ID no. and ID_Date.
Now
Example 1:
In Table A, Task No. 1, Part No. A and Created Date: 08/07/2013 10:27:03
Now i want to get ID No from Table B according to part no. and created date.
Task No. 1, Part No. A and Created date: 08/07/2013 10:27:03, So for same part no. immidiate first less date of created date in Table B is 08/07/2013 10:20:00
So ID No is ID_1
Example : 2
Task No. 3, Part No. A and Created date: 08/07/2013 12:27:03, So for same part no. immidiate first less Id_date of created date in Table B is 08/07/2013 10:30:00
So ID No is ID_2
Example : 2
Task No. 4, Part No. C and Created date: 08/07/2013 13:07:00, So for same part no. immidiate first less Id_date of created date in Table B is 08/07/2013 11:30:00
So ID No is ID_5
TABLE: A
TASK NO. | CREATED BY | PART_NO | CREATED DATE |
---|---|---|---|
1 | AAA | A | 08/07/2013 10:27:03 |
2 | AAA | B | 08/07/2013 11:00:00 |
3 | AAA | A | 08/07/2013 12:27:03 |
4 | BBB | C | 08/07/2013 13:07:00 |
5 | CCC | B | 08/07/2013 14:20:03 |
TABLE: B
PART_NO | ID | ID_DATE |
---|---|---|
A | ID_1 | 08/07/2013 10:20:00 |
A | ID_2 | 08/07/2013 10:30:00 |
B | ID_3 | 08/07/2013 11:30:00 |
B | ID_4 | 08/07/2013 12:00:00 |
C | ID_5 | 08/07/2013 11:30:00 |
Please let me know how do i achive this result?
Thanks
Try the Interval function.
See attached qvw.
Hi Gysbert,
I have a qvw file scheduled based on another qvw filw succeded the reload ifs fine in the physical folder but the task status is still showing running and it is showing Abort Reload button enable it doesn't go to grey but the other tasks are fine Could you help me what is the problem
This sounds like the old server bug, you will need to restart the services and probably update to a new SR