跳到主要內容

The Qlik February 2020 release has been delayed by a couple of weeks due to a security vulnerability that recently surfaced with Node.js, which is impacting a large portion of the software industry. The release is expected to be delivered before the end of the month, with a target date of February 25th, as Qlik is actively running tests to ensure that the February GA release is stable and not affected by this security malware.
To read more about this vulnerability: https://nodejs.org/en/blog/vulnerability/february-2020-security-releases/

QlikWorld 2020 全球會議。Keynote 講者 Malcolm Gladwell。立即註冊並儲存

FileBaseName - 指令碼函數

FileBaseName 函數會傳回一個字串，其中包含目前正在讀取之表格檔案的名稱，不含路徑或副檔名。

Syntax:

FileBaseName()

範例	結果
LOAD *, filebasename( ) as X from C:\UserFiles\abc.txt	會在每筆讀取的記錄中，於欄位 X 傳回 'abc'。

範例

結果

LOAD *, filebasename( ) as X from

C:\UserFiles\abc.txt

會在每筆讀取的記錄中，於欄位 X 傳回 'abc'。