Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Loading excel data into QVD files

Please advise as to what is wrong with this script below. Thank you.

















NetworkAttacksDB:

LOAD

// No.,

[Filter No.]

,

[Filter Name]

,

[Source IP Address]

,

[Dest IP Address]

,

Action

,

Severity

,

Hits

,

Date

(AddMonths(today(), -1)) as

EntryDate

FROM

(

ooxml, embedded labels, table is [Network Attacks]

)

WHERE

FileTime() >= #$(LastExecTime)

#

AND

FileTime() < #$(BeginningThisExecTime)

#;

Concatenate

LOAD * FROM

SecurityKPIs.qvd;

Store

NetworkAttacksDB INTO

SecurityKPIs.qvd;





0 Replies