Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I'm trying to create a Straight Table with just today's date. My problem is that the dates I'm using are in a strange format:
Actual Start/End Date: 1YYMMDD
1150602 = 02/06/2015
In this example, I want to end up with a table that has just Run1's and Run2's (as they match in both tables) and only the results that will match today's date - in this case 4 results match 02/06/2015.
Scheduled Runs
Name | Description |
---|---|
Run1 | ABC |
Run2 | 123 |
Run3 | XYZ |
Run4 | 456 |
Actual Runs
Name | Status | Actual Start Date | Actual End Date |
---|---|---|---|
Run1 | C | 1150529 | 1150529 |
Run1 | C | 1150603 | 1150602 |
Run1 | F | 1150603 | 1150602 |
Run2 | F | 1150601 | 1150602 |
Run2 | C | 1150603 | 1150602 |
Run2 | C | 1150603 | 1150602 |
Run6 | C | 1150603 | 1150602 |
Run7 | C | 1150603 | 1150602 |
Any help is greatly appreciated.
Kind regards,
Tristan
Maybe like attached?
Maybe like attached?
actrun:
LOAD Name,
Status,
date(date#(right([Actual Start Date],6),'YYMMDD')) as [Actual Start Date],
date(date#(right([Actual End Date],6),'YYMMDD')) as [Actual End Date]
FROM
[https://community.qlik.com/thread/166596]
(html, codepage is 1252, embedded labels, table is @2)
Where
date(date#(right([Actual Start Date],6),'YYMMDD')) = Today(1)
and [Actual Start Date] = [Actual End Date]
;
schrun:
inner Keep (actrun)
LOAD Name,
Description
FROM
[https://community.qlik.com/thread/166596]
(html, codepage is 1252, embedded labels, table is @1);
Thanks very much Swuehl, that's nailed it!
Kind regards,
Tristan