Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I'd like join a load based on filetime. Because I know in older files the fields are not as complete as the latest.
I've looked on this forum tried here en there, but unfortunately no result.
Help would be appreciated!
JiraTestRapportageInfo_ExtraVelden:
Left join
LOAD
FileTime() as FileDD,
[TEST CASE] as TestCase,
[TEST CASE ASSIGNEE] as JirTestCase_Assignee,
[TEST CASE EXECUTE] as JirTestCase_Execute
FROM
$(StdPathQVIMPORT)\QV_JIRA\*.xlsx
(ooxml, embedded labels)
WHERE Date(Date#(FileDD,'DD/MMM/YYYY hh:mm:ss')) > Date(Date#('27/08/2020 12:00:00', 'DD/MMM/YYYY hh:mm:ss'));
JiraTestRapportageInfo:
LOAD
//FileTime() as TestRapportdd,
Timestamp(num(FileTime()), 'dd-MM-YYYY hh:mm:ss') as TestRapportdd,
left(FileName(), 14 + SubStringCount(FileName(), ' ')) & ' ' & Timestamp(num(FileTime()), 'dd-MM-YY') as TestRapportName,
trim(left(FileName(), 14 + SubStringCount(FileName(), ' '))) as TestRapportNameFilter,
//30+SubStringCount(FileName(), 'I') as RUN,
[TEST CYCLE] as TestCycle,
[TEST CASE] as TestCase,
[TEST CASE STATUS] as JiraTestRapTestCase_Status,
EXECUTION as JiraTestRapExecution,
STEP as JiraTestRapStep,
STATUS as JiraTestRapStepStatus,
ISSUE as JiraTestRapIssue
FROM
$(StdPathQVIMPORT)\QV_JIRA\*.xlsx
(ooxml, embedded labels);