Load data based on filetime

[stevenpiers]

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);